topic Re: how to build a X-reference function in script in QlikView

how to build a X-reference function in script

Fri, 28 Nov 2014 13:03:53 GMT

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 — Fri, 28 Nov 2014 13:25:54 GMT

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;

Fri, 28 Nov 2014 13:39:30 GMT

Thanks Michele, the scripts work perfect!