How to allocate a default value if the data is missing

[#1]

Hi,

a bit of coding help required. I have two spreadsheets from two different sources. In one of the spreadsheets that I am loading, it does not hold data for the country (wierd I know).

what I want to do is assign a text value during the load process that will identify that the data is missing. Add in the word 'Missing'.

I have tried the IsNull but I don't think the source field is being recognised as a null, just a Blank or empty string.

How do I code around this?

All replies gratefully recieved.

Jim

[PrashantSangle]

Hi,

Try

if(len(Trim(fieldName))<1,'Missing',fieldName)

Or

if(Isnull(fieldName),'Missing',FieldName)

[alexandros17]

Load

     ...

     if(isnull(Country) or Trim(Country)='', 'Missing', Country) as Country

     ...

Resident myTable;

Let me know

[#4]

Thank you - worked a treat

[#5]

Thanks Alessandro - very helpful