Mapping two differents table

[#1]

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

[ankitaag]

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 · Accepted solution]

Use Applymap() and mapping functions.

[#4]

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]

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