Perform GeoTAX Address Operation - Precisely Data Integrity Suite

create or replace table geotax_result as 
select ID,addressline1,city,state,zip,  
    object_construct( 
      'addressId', iff(ID is not null, ID,''),
      'addressLines', array_construct(iff(ADDRESSLINE1 is not null, ADDRESSLINE1,'')),
      'admin1', state,
      'city', city,
      'postalCode', zip
) as geotaxObject
, geotax_address(geotaxObject)
as geotaxResponse from GEOTAX_LOCATIONS order by zip;