Discussion Board for collaboration on QlikView Scripting.
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".
Use Applymap() and mapping functions.
View solution in original post
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,
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..