Discussion Board for collaboration on QlikView Scripting.
I am wondering if I can build a X-reference function using Qlikview script
first, I load a Xref_table which contains the mapping logic, here I used 3 fields as inputs and 1 field as mapping output
then, I load a In_file which contain the data to be mapped
finally, I want to get a Out_file which contains both Input data and mapping result
My questions are, is this possible in QV? What is the most efficient way then?
Thanks a lot!
Go to Solution.
maybe with a script like
load In1 as I1, In2 as I2, In3 as I3
Left join (Out_file)
Load Input1 as I1, Input2 as I2, Input3 as I3, Map1 as M1
Thanks Michele, the scripts work perfect!