topic Re: Applymap in App Development

Applymap

niranjana — Sat, 08 Jan 2022 07:25:10 GMT

Hi All, I have a requirement where I have to bring one filed from an excel file loaded into a QVD which also is loaded in the script. I used applymap function but its not working. The Key field used to join is not working. Any help is appreciated.

For example,

table1:

Load

field1,

filed2 ,

field1 & field 2 as key,

field 3

etc from excel file;

mapping load:

key ,

field 3

resident table1;

table2:

load

field 1

field 2,

applymap('maping table',key,null()) as field 3

from QVD;

I want to bring field 3 into table2

Re: Applymap

anat — Sat, 08 Jan 2022 07:38:19 GMT

load

field1 & field 2 as key,

field 1

field 2,

applymap('maping table',key,null()) as field 3

from QVD;

Re: Applymap

niranjana — Sat, 08 Jan 2022 08:02:27 GMT

Can you pls give full approx. script , for ex where should I put they "Key" field? in all three tables: table1, mapping load and table 2?

Re: Applymap

MarcoWedel — Sat, 08 Jan 2022 11:59:58 GMT

please post some sample data and your expected result.

thanks

Re: Applymap

anat — Sat, 08 Jan 2022 13:33:36 GMT

table1:

Load

field1,

filed2 ,

field1 & field 2 as key,

field 3

etc from excel file;

mapping load:

key ,

field 3

resident table1;

table2:

load

field1 & field 2 as key,

field 1,

field 2,

applymap('maping table',key,null()) as field 3

from QVD;

Re: Applymap

rwunderlich — Sat, 08 Jan 2022 16:36:18 GMT

Something is incomplete here. You show a reference to 'maping table' but don't show it loading in the script.

-Rob

Re: Applymap

Vishal_Gupta — Sun, 09 Jan 2022 08:17:14 GMT

Hi @niranjana

Problem with your script is that you are not defining correct mapping field in your 3rd table i.e. qvd table

While there can be multiple ways to handle this, you can try the below script and let me know if it works for you

Table1:
Load
field1,
filed2 ,
field1 & field2 as key,
field 3
etc from excel file;

Mapping Table:
mapping load
key,
field 3
resident Table1;

Table2:
load
field 1
field 2,
applymap('Maping Table',field1 & field2,null()) as field 3
from QVD;

Also note that mapping load table can only have unique values.