topic Edit Script Condition... in QlikView

Edit Script Condition...

Wed, 14 Jul 2010 09:01:40 GMT

Hi;

LOAD

a,
b,
c

FROM ...

LOAD

x,
y,
z

FROM ...

LOAD

k,
l,
m

FROM ...

i would like to write an if condition just like <if(a=x,k)> in edit script (data load page)

i try it in straight table but after that my app slow down.

How can i do it, is it possible or not?

Thanks in Advance

Edit Script Condition...

Wed, 14 Jul 2010 11:02:58 GMT

Edit Script Condition...

sunil2288 — Wed, 14 Jul 2010 11:19:35 GMT

Hi Seluck,

At first u need to link the three tables to create a data cloud.After that only u can compare those values in if condition..

Thanks,

Suneel

Edit Script Condition...

Wed, 14 Jul 2010 12:14:27 GMT

Hi Sunil;

Thank you for your answer. I research about create a data cloud but i do not understant clearly.

could you give me more info about that please?

Thank you...

Edit Script Condition...

sunil2288 — Thu, 15 Jul 2010 05:56:10 GMT

Hi Seluck,

According to u have 3 tables to load.u need to define the association key for all the three table..Like in

1st table u can take 'a' as foreign key which link to the 'y' coloumn of the 2nd table.

Then to link 2nd and 3rd table u can take 'z 'as foreign key which link 'l' coloumn of the third table.

To do this u need to rename the colomn.

1>in Load script Take 'a' as 'Key_First'.in the 1st table.

2>Take 'y' as 'Key_First' in the 2nd table.

3>take 'z' as 'Key_Second' in the 2nd table.

4>take 'l' as 'Key_Second' in the 3rd table.

U can create associativity like this.

Thanks,

Suneel