topic Re: Apply Map Help in QlikView

Apply Map Help

Mon, 11 Jan 2016 04:43:32 GMT

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.

Re: Apply Map Help

sunny_talwar — Mon, 11 Jan 2016 17:00:31 GMT

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

Re: Apply Map Help

miguelbraga — Mon, 11 Jan 2016 17:00:44 GMT

Did you tried replacing '' with null() ?

Regards,