Data load and if/then/else statements

[Breezy]

Hi,

I uploaded my Excel document and it has numbers (as text; I'm not doing sums, etc.). Some of the cells have 'Not Available'. I can't figure out how to say "If the population count is 'not available' then put 'not available' in the cell. Otherwise input whatever is in the population count cell in the Excel doc.

Here's what I tried. It did not work though (error during data load script)

If ("PopulationCount" = 'Not Available', 'Not Available', "PopulationCount")

[jwjackso]

The ALT  function may work for you.

Alt([PopulationCount],'Not Available') as [PopulationCount]

[Breezy]

Thank you. I am copying and pasting that syntax but alas, it's not resolving the issue.

[jwjackso]

Add the Num  function around the [PopulationCount] to convert it to a number for the Alt function

Alt(Num([PopulationCount],'Not Available') as [PopulationCount]

[Breezy]

Hmm, the 'as' turned red and the second part of the clause was pinked out (both for 'error').

I added an ')' at the end but it did not do the trick.

Alt(Num([PopulationCount],'Not Available') as [PopulationCount])

[jwjackso]

I can't type

Alt(Num([PopulationCount]),'Not Available') as [PopulationCount]

[Breezy]

Hi,

I still can't get it. Question for you - if I were to change the heading to Pop Count would I need quotes around Pop Count since there's a space?

[jwjackso]

Yes, you could use double-quotes or [ ] for fields with spaces in the name.

[Breezy]

Well, it loads but it still doesn't reflect it in the table. I must be missing something.