Why is Set variable dollar expansion not working?

mwallman — Fri, 13 Jul 2018 08:50:00 GMT

Hi,

I have a script like this in my app:

NULLASVALUE Country, Product, CustomerName;

SET NullValue = 'Not Found';

LOAD

<Fields>,

Country,

If(Country=$(NullValue), Null(), Country) as CustomerCountry

Resident <Table>

My NullValue dollar expansion is not working.

Any idea what I am doing wrong please?

I cannot remove the field from NULLASVALUE because it is required.

Re: Why is Set variable dollar expansion not working?

YoussefBelloum — Fri, 13 Jul 2018 08:57:02 GMT

Hi,,

I think you should write it like this:

If(Country='$(NullValue)', Null(), Country) as CustomerCountry