topic Mapping two differents table in QlikView

Mapping two differents table

Fri, 24 Apr 2015 07:46:36 GMT

Hi,

I need to make a mapping with 2 differents table like:

Excel 1
cell 1
cell 2
cell 3
cell 4
cell 5

Excel 2
cell 1
cell 2
cell 5

What I want to do is to pass every data from Excel 2 to Excel 1 and force the values of 3 and 4 to "0".

Regards

Re: Mapping two differents table

ankitaag — Fri, 24 Apr 2015 08:16:01 GMT

Hi Kenny,

Try this,

T1:

Load * Inline [

Excel1

cell 1

cell 2

cell 3

cell 4

cell 5

] ;

T2:

Load * Inline [

Excel2, data

cell 1, a

cell 2, b

cell 3, c

] ;

Map:

Mapping Load

Excel2,data

Resident T2;

drop table T2;

Final:

Load Excel1,ApplyMap('Map',Excel1,0) as data

Resident T1;

drop table T1;

Thanks and Regards,

Ankita

Re: Mapping two differents table

buzzy996 — Fri, 24 Apr 2015 11:59:56 GMT

Use Applymap() and mapping functions.

Re: Mapping two differents table

Fri, 24 Apr 2015 15:20:06 GMT

Thanks for your answer!

Actually I tried with an outer join, but I think it's maybe too simple. I'll try your option

Re: Mapping two differents table

ankitaag — Mon, 27 Apr 2015 07:24:06 GMT

Hi Kenny,

If you find any of the answer as helpful then please mark it as helpful or correct so as to close the discussion..

Thankyou