Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

how to build a X-reference function in script

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!

Xref in QV.jpg

1 Solution

Accepted Solutions
bbi_mba_76
Valued Contributor

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

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;

2 Replies
bbi_mba_76
Valued Contributor

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

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;

Not applicable

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

Thanks Michele, the scripts work perfect!

Community Browser