Apply Map Help

[#1]

Hi Community,

I have written Apply map function, to fetch the values only if ColumnA values are not null. But values are fetching for the null values also. I have written a where clause in the mapping load also.

If(ColumnA<>'',Applymap(Mappingtable,Key,'NA'))

Please help me here, I dont require the values to be fetched for the null values...

Thanks in advance.

[sunny_talwar]

I am not sure how is it even fetching anything. As far as I know, the table name needs to be within single quotes

Not entirely sure what you are doing, but may be this:

If(Len(Trim(ColumnA)) > 0, ApplyMap('MappingTable', Key, 'NA')) as NewField

[miguelbraga]

Hi

Did you tried replacing '' with null() ?

Regards,

MB