topic Re: How-To: Add Code to your Content in QlikView

How-To: Add Code to your Content

Mon, 12 Aug 2013 09:26:17 GMT

how to define this condition
if(tab1.dept_id='global' then tab2.dept_id
else tab1.dept_id)

in tab1 table, if the script is as below;

Qualify b_id;

oad a,d,c,b_id,dept_id;

SQL select * from tab1;

Qualify b_id;

load f,g,j,kk,

b_id,dept_id;
SQL Select * from tab1;

Re: How-To: Add Code to your Content

Miguel_Angel_Baeyens — Mon, 12 Aug 2013 09:35:49 GMT

Hi,

You should use a mapping load with an ApplyMap(), as follows:

Table2Map;
MAPPING LOAD b_id, dept_id; // b_id or the unique identifier between both tables
SQL select * from tab1;

Table1:
LOAD f, g, j, kk,
      b_id,
      If(dept_id = 'global', ApplyMap('Table2Map', b_id), dept_id) AS dept_id_new;
SQL Select * from tab1;

Hope that helps.

Miguel

Re: How-To: Add Code to your Content

Wed, 11 Dec 2013 00:21:44 GMT

Thank you