Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Mapping two differents table

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

Tags (2)
1 Solution

Accepted Solutions
buzzy996
Honored Contributor II

Re: Mapping two differents table

Use Applymap() and mapping functions.

4 Replies
ankitaag
Contributor III

Re: Mapping two differents table

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

buzzy996
Honored Contributor II

Re: Mapping two differents table

Use Applymap() and mapping functions.

Not applicable

Re: Mapping two differents table

Thanks for your answer!

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

ankitaag
Contributor III

Re: Mapping two differents table

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

Community Browser