Hi
In my project, we are preprocessing on Address columns and area columns. After this we are doing the standardization as per client's requirements. His requirement is to have Apartment in address line 2.
We are using the USADDR.set and USAREA.set for this.
But somehow, when feeding ths standardized output to CASS stage, it is pushing the APT value to address line 1. This is not happening for all the records but for few.
For eg:
After standardization:
addr_1, addr_2
"175 BLEECKER ST", "APT 12";
Output after CASS:
addr1, addr2
"175 BLEECKER ST APT 12", null
Appreciate your earlier response.
Thanks in advance!