topic Re: Apply Map in QlikView

Apply Map

solomonadjei — Wed, 25 Nov 2020 16:16:04 GMT

Afternoon Experts,

Could anyone help me understand why I do get "Field not found error / Field 'STP' not found " from below script.

Thanks.

Re: Apply Map

sunny_talwar — Wed, 16 Jan 2019 12:49:02 GMT

Try this

ApplyMap('Table', [TRUST CODE]) as STP

Re: Apply Map

Gysbert_Wassenaar — Wed, 16 Jan 2019 12:49:17 GMT

You're only loading the fields [TRUST CODE] and [TRUST NAME] from the TRUSTS.xls file. You don't load an STP field from the source file so you can't use STP in that load statement as a source field.

Re: Apply Map

punitpopli — Wed, 16 Jan 2019 12:56:15 GMT

Apply Map will work when you have the filed already in the table you are referring, as your STP filed is not available in the load statement its giving error.

either follow the solution what Sunny had suggested or try below :

Load *,

ApplyMap('Table', STP) as STP;

Load

[TRUST CODE]

[TRUST NAME] as STP

from table name;

Re: Apply Map

pradosh_thakur — Wed, 16 Jan 2019 13:03:40 GMT

Assuming that you want to compare [Trust Name] in both tables and want to populate [stp] for the same you need to use applymap('Table',[TRUST NAME]) AS [stp]

again the mapping table columns need to be in a key -value order. so what ever is the key( the column you need to compare) should be in the first place
so
mapping load
[Trust Name],
[STP]

from ......

Re: Apply Map

solomonadjei — Wed, 16 Jan 2019 16:59:59 GMT

Thanks Gysbert,

Really appreciate your respond. how would you write the script as i have tried all the suggestion and still not working.

Re: Apply Map

solomonadjei — Wed, 16 Jan 2019 17:02:18 GMT

Thanks pradosh_thakur ,
Am still struggling to excecute the script. still not doing what I want.

Re: Apply Map

solomonadjei — Wed, 16 Jan 2019 17:03:06 GMT

Many thanks for promt respond. Am still struggling to get it working.

Re: Apply Map

Gysbert_Wassenaar — Thu, 17 Jan 2019 06:53:39 GMT

ApplyMap('Table', [TRUST CODE], 'No value found') as STP

Re: Apply Map

pradosh_thakur — Thu, 17 Jan 2019 08:21:46 GMT

copy paste the part of the code where u are using applymap. If our solution doesn't work. It will be easier to help you out

Re: Apply Map

solomonadjei — Thu, 17 Jan 2019 16:16:05 GMT

THANKS 🙂

Re: Apply Map

solomonadjei — Thu, 17 Jan 2019 16:16:28 GMT

Thanks

topic Re: ***Apply Map*** in QlikView

***Apply Map***

Re: ***Apply Map***

Re: ***Apply Map***

Re: ***Apply Map***

Re: ***Apply Map***

Re: ***Apply Map***

Re: ***Apply Map***

Re: ***Apply Map***

Re: ***Apply Map***

Re: ***Apply Map***

Re: ***Apply Map***

Re: ***Apply Map***

topic Re: Apply Map in QlikView

Apply Map

Re: Apply Map

Re: Apply Map

Re: Apply Map

Re: Apply Map

Re: Apply Map

Re: Apply Map

Re: Apply Map

Re: Apply Map

Re: Apply Map

Re: Apply Map

Re: Apply Map