map 2 different field from 2 different data source

[#1]

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]

Hi

Rename fields with Same name .

[#3]

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

[#4]

HI Hamide

pls Check this sample app.

[maxgro]

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;