Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
Can anyone tell. how to write this SQL logic in qlikview.
MERGE INTO sale s
2 USING (SELECT ROWID rid, sale_at, product_id
3 FROM sale
4 WHERE product_id IN (SELECT parent_id FROM split)
5 UNION ALL
6 SELECT CAST (NULL AS ROWID) rid, sale_at, child_id FROM sale
7 JOIN split ON (parent_id = product_id)) m
8 ON (s.ROWID = m.rid)
9 WHEN MATCHED THEN
10 UPDATE SET s.sale_at = m.sale_at
11 DELETE WHERE 1 = 1
12 WHEN NOT MATCHED THEN
13 INSERT VALUES (m.sale_at, m.product_id);
regards,
Ganesh
This command is an update-like statement, do you need to update your database or a table inside your Qvw?
Hi Clever,
I need to update table inside qvw.
Regards,
Ganesh
May be Dynamic Update is what you need.