Why is Set variable dollar expansion not working?

[mwallman]

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.

[YoussefBelloum]

Hi,,

I think you should write it like this:

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