Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Use Applymap() and mapping functions.
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
Use Applymap() and mapping functions.
Thanks for your answer!
Actually I tried with an outer join, but I think it's maybe too simple. I'll try your option
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