Zip code mapping issue on transform map

[Developer3]

I created a transform map where in we have zip code values provided in the excel like 711-012 or 0511 etc. In both these cases, during transformation, target zip code field is getting updated as 711012 (- is removed) and 511 (0 is removed).

How can we prevent this and update the exact zip code value with out any data getting formatted?

[Krushna R Birla]

Hi @Developer3 

You can directly map the field using

target.zip_code = source.zip_code;

If it wont work then please share the snapshot of your requirement, I would be happy to help you.

If this solution resolves your query, kindly mark it as the accepted solution and give it a thumbs up.

Best Regards,
Krushna Birla

[Nicholas_Gann · Accepted solution]

Does the data appear correct in the staging table prior to transform? This seems a bit odd as the Zip / Postal Code is a string field and I would not have thought a standard field mapping would mess with the source data prior to populating the target field. I've assumed you're mapping to the Locations 'zip' field, which is a string and doesn't seem to have any form of validation on it