topic UPDATE SQL in QlikView

UPDATE SQL

Hemanth458 — Thu, 09 May 2019 04:19:59 GMT

Hi All,

How to update records in Qlik like SQL

Ex: Update ABC Set Date=C_Date_To_NULL(t.Date),Date1=C_Date_To_NULL(t.Date1),Category = (case where Date>='31/03/2019' Then 'Q1', where Date>=30/06/2019 then 'Q2' End) from ABC c,Temp t where c.id=t.id

How can I achieve it in qlik

Re: UPDATE SQL

Albert_Candelario — Thu, 09 May 2019 06:19:42 GMT

Hi,

Would you mind to elaborate a bit more what are you trying to achieve? But, maybe the partial reload would be helpul for this use case. You can do a partial reload and only the tables with a REPLACE or ADD will be updated. The rest of tha data will remain the same.
You can see more details in:
https://community.qlik.com/t5/QlikView-Documents/Partial-Reload-Easy-and-Simple/ta-p/1491323
or
https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/Partial%20Reload.htm
Cheers!