***Apply Map***

[solomonadjei]

Afternoon Experts,

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

Thanks.

[sunny_talwar · Accepted solution]

Try this

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

[Gysbert_Wassenaar · Accepted solution]

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.

[punitpopli · Accepted solution]

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;

[pradosh_thakur · Accepted solution]

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 ......

[solomonadjei]

Thanks Gysbert,

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

[solomonadjei]

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

[solomonadjei]

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

[Gysbert_Wassenaar]

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

[pradosh_thakur]

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