Discussion Board for collaboration related to QlikView App Development.
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!
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
That works, as you have demonstrated, in SQL. I'm talking about Qlikview Dynamic Updates