topic Re: replace qvd field value in QlikView

replace qvd field value

Wed, 23 Jul 2014 14:36:47 GMT

Hello,

I am having a qvd with field name Item_No, Name.

I have field values for Item_No as 1, 2, 3

Now I have to replace Field value 1 as 4 in that qvd, So the new values should be 4,2,3.

for ex: if(Item_No=1, 4,Item_no)

How should I write this logic in Script.

Thanks

alexandros17 — Wed, 23 Jul 2014 14:38:42 GMT

Table:

Load If(Item_No=1,4,Item_No) as Item_No, .... from xxx.qvd;

Store * from Table into xxx.qvd;

let me know

Wed, 23 Jul 2014 14:42:12 GMT

Tq its working