topic Re: Develop the code in QlikView

Develop the code

pavanthota — Wed, 02 May 2012 11:34:08 GMT

Hi ,

I am new to the Qlikview i want to Populate the date with some conditions. Can anyone assist to develop the code

I have two tables

Table1:

A B C D

1 2 9

3 4 10

5 6 11 25

7 8 12

Table 2:

A B C H

11 12 15 21

1 2 9 22

3 4 10 23

5 6 11 24

7 8 12 27

Here is the data i want output as the table 1

Conditions:

I want to populated the "H" field data into table 1 "D" field where D is null values and i want to satisfy the below conditions also

Table1.A=Table2.A

Table1.B=Table2.B

Table1.C=Table2.C

Can you please any one help on this

Develop the code

clisboa_noesis — Wed, 02 May 2012 11:42:47 GMT

Hi Pavan,

The easiest way to me seems to be the ApplyMap.

First you need to load table2 has an mapping:

Table2:
Mapping
LOAD
A & B & C as Key,
H as D
FROM ...

And then when you load table1 you can simply:

Table1:
LOAD
     A,
     B,
     C,
     alt(D,ApplyMap('Table2', A&B&C, null() )) as D
From ...

alt returns the first non null value, so if D is null it will return the applymap for that record.

Hope this helps

Regards

Carlos

Develop the code

pavanthota — Wed, 02 May 2012 13:17:48 GMT

Thanks carlos for ur help

But i dont want to update "D" field if it has value. can you help me on that

Develop the code

clisboa_noesis — Wed, 02 May 2012 13:49:07 GMT

Pavan,

That's what alt is for, if D has value then it's that value that is returned, if it's null then what gets returned is the applymap.

Regards,

Carlos

Re: Develop the code

SunilChauhan — Wed, 02 May 2012 14:09:30 GMT

see the attched file

hope this helps

Re: Develop the code

pavanthota — Wed, 06 Jun 2012 13:34:50 GMT

Hi Carlos

Can you explain me how mapping internaly works and can you give brief documentation for that

Thanks

Pavan