Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
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
Highlighted
Honored Contributor II

Re: Mapping two differents table

Use Applymap() and mapping functions.

View solution in original post

4 Replies
Highlighted
Partner
Partner

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

Highlighted
Honored Contributor II

Re: Mapping two differents table

Use Applymap() and mapping functions.

View solution in original post

Highlighted
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

Highlighted
Partner
Partner

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