how to build a X-reference function in script

[#1]

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!

[bbi_mba_76 · Accepted solution]

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;

[#3]

Thanks Michele, the scripts work perfect!