topic Dynamic Update - WHERE ID IN (1,2,3,4) in QlikView

Dynamic Update - WHERE ID IN (1,2,3,4)

Tue, 28 Mar 2017 10:03:43 GMT

Can anyone help me to get the correct dynamic update syntax here

These don't seem to work

UPDATE TABLENAME SET GROUPID = 1 WHERE ID IN (1,2,3,4);

UPDATE TABLENAME SET GROUPID = 1 WHERE ID=1 OR ID=2 OR ID=3 OR ID=4;

Thanks in advance!

Felix

yoganantha321 — Tue, 28 Mar 2017 11:03:06 GMT

Hi Richard,

I have tried with the first one update query it is working perfectly,

Kindly try once again with

Update <tablename> set <fieldname> =<value> where <fieldname> in (<values for condition>);

Example I have used the below expression,

Update dbo.tbl_Womens_Registration set emp_Id =1 where emp_id in(101,102,103);

and got output as shown below

Tue, 28 Mar 2017 15:41:40 GMT

That works, as you have demonstrated, in SQL. I'm talking about Qlikview Dynamic Updates