topic Re: How to write sql logic in qlikview in QlikView

How to write sql logic in qlikview

ganeshreddy — Fri, 20 Nov 2020 18:02:30 GMT

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

Clever_Anjos — Tue, 24 Nov 2015 15:37:54 GMT

This command is an update-like statement, do you need to update your database or a table inside your Qvw?

ganeshreddy — Wed, 25 Nov 2015 08:15:54 GMT

Hi Clever,

I need to update table inside qvw.

Regards,

Ganesh

tresB — Wed, 25 Nov 2015 08:36:34 GMT

May be Dynamic Update is what you need.