Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
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!
Hi,
maybe with a script like
<...>
Out_file:
load In1 as I1, In2 as I2, In3 as I3
resident In_file;
Left join (Out_file)
Load Input1 as I1, Input2 as I2, Input3 as I3, Map1 as M1
resident Xref_table;
Hi,
maybe with a script like
<...>
Out_file:
load In1 as I1, In2 as I2, In3 as I3
resident In_file;
Left join (Out_file)
Load Input1 as I1, Input2 as I2, Input3 as I3, Map1 as M1
resident Xref_table;
Thanks Michele, the scripts work perfect!