I need to make a mapping with 2 differents table like:
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".
Load * Inline [
cell 1, a
cell 2, b
cell 3, c
drop table T2;
Load Excel1,ApplyMap('Map',Excel1,0) as data
drop table T1;
Thanks and Regards,
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
If you find any of the answer as helpful then please mark it as helpful or correct so as to close the discussion..
Retrieving data ...