RE:Loading table

kamielrajaram — Fri, 28 Oct 2011 12:43:28 GMT

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

RE:Loading table

Fri, 28 Oct 2011 13:10:27 GMT

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.

topic RE:Loading table in QlikView

RE:Loading table

RE:Loading table