topic Re: ApplyMap function in Resident Load in QlikView

ApplyMap function in Resident Load

Fri, 27 Mar 2015 12:52:28 GMT

Hi Team,

I want to use apply map function in a resident table.

I am in dilemma whether it is possible or not.

I have attached my qvw file.

Regards,

Priyanka

Re: ApplyMap function in Resident Load

buzzy996 — Fri, 27 Mar 2015 12:55:38 GMT

I believe u can use the same manner however we use in load script with mapping table.

Re: ApplyMap function in Resident Load

Anonymous — Fri, 27 Mar 2015 12:56:38 GMT

You can certainly use ApplyMap() in a Resident Load..

Re: ApplyMap function in Resident Load

stigchel — Fri, 27 Mar 2015 13:00:25 GMT

Yes you can, but it should be

ApplyMap('Cource_Name',Subfield(Type, ' ',1),Null()) as Subject,

Instead of the out commented line in the script you have

Re: ApplyMap function in Resident Load

Fri, 27 Mar 2015 13:53:06 GMT

Thanks Piet, It worked

Re: ApplyMap function in Resident Load

stigchel — Fri, 27 Mar 2015 13:58:56 GMT

You're welcome Priyanka.

If this has answered your question can you please close this thread by marking one of the answers correct? It will help others find a (correct) answer to similar problems and lets other contributing members know that this requires no more attention.

Thanks,

Piet Hein