topic Re: map 2 different field from 2 different data source in QlikView

map 2 different field from 2 different data source

Sun, 13 Sep 2015 10:45:40 GMT

hi every one,

i have one field like id in one data source:

id is : 2,3,4,5

and similar that file named code in other data source,

code is : 10243,10244,10370,10440

i want map this two field in one field named code.

how can i do this ?

regards

Anonymous — Sun, 13 Sep 2015 10:58:38 GMT

Rename fields with Same name .

Sun, 13 Sep 2015 11:08:15 GMT

thanks

but it dosn't work

i explain more :

id and code , both of them refer to student code in different data source, id in finance data source and code in HR data source,

id=2 is student with code =10243

i want create one field , then when i choose new field , it's refer to both of them

Sun, 13 Sep 2015 11:56:07 GMT

HI Hamide

pls Check this sample app.

maxgro — Sun, 13 Sep 2015 13:42:46 GMT

you need a mapping (decod) from

- id to newfield (Mapid)

- code to newfield (Mapcode)

in Qlik define the 2 mapping table

Mapid:

Mapping load id, newfield from ....;

Mapcode:

Mapping load code, newfield from .....;

then load the table from finance data source and hr data source, they will be associated by Newfield

Finance:.

load

id,

ApplyMap('Mapid', id) as Newfield

from financedatasource;

HR:

load

code,

ApplyMap('Mapcode', code) as Newfield

from hhrdatasource;