RE:Loading table

[kamielrajaram]

Good day,

Please could you assisit with the following,

I have 1 address table with 2 address types namely home and postal. Some records have a postal code for both types, this is fine as Iwill always use the postal address. the issue comes in when the postal code for the postal address is missing,but exists in the home type, then I will require the postal code for the home type.

thanks in advance

Kamiel

[#2 · Accepted solution]

I think you are having two records, one for each of the address type. If you slipt them into two and join them into one record then you can create a new field, DesiredPostalCode in address table as below:

if(isNull(Postal_PostalCode),Home_PostalCode,Postal_PostalCode).

This should solve your problem.

Kiran.