topic Re: Update existing QVD in QlikView

topic Re: Update existing QVD in QlikView https://community.qlik.com/t5/QlikView/Update-existing-QVD/m-p/1573202#M442324 <P>Hello,</P><P>One idea would be to load the qvd that you currently have in 3 parts (one per day). Then you would have to join with LEFT JOIN. Finally you should export the new table in a new QVD.</P><P>I think that for the following loads, you should be able to see if you can load the QVD from days 2 and 3 with LEFT JOIN, instead of concatenating them.</P><P>I leave an example of the script.</P><P>///DAY 1<BR />DEF:<BR />LOAD Id,<BR />Status,<BR />S_Initial_Date<BR />FROM<BR />YOUR_ACTUAL_FILE.qvd<BR />(qvd) WHERE NOT ISNULL(S_Initial_Date);</P><P>//DAY 2<BR />LEFT JOIN(DEF)<BR />LOAD Id,<BR />S_Work_In_Progress_Date<BR />FROM<BR />YOUR_ACTUAL_FILE.qvd<BR />(qvd) WHERE NOT ISNULL(S_Work_In_Progress_Date);</P><P>///DAY 3<BR />LEFT JOIN(DEF)<BR />LOAD Id,<BR />S_Completion_Date<BR />FROM<BR />YOUR_ACTUAL_FILE.qvd<BR />(qvd) WHERE NOT ISNULL(S_Completion_Date);</P><P><BR />NoConcatenate<BR />DEF_OK:<BR />LOAD<BR />Id,<BR />IF(NOT ISNULL(S_Completion_Date), 'Complete', IF(NOT ISNULL(S_Work_In_Progress_Date), 'Work In Progress', 'Initial')) AS Status,<BR />S_Initial_Date,<BR />S_Work_In_Progress_Date,<BR />S_Completion_Date<BR />FROM DEF;</P><P>DROP TABLE DEF;</P><P>store * from DEF_OK into FINAL.qvd</P><P>a greeting</P><P> </P><P> </P><P> </P><P> </P> Thu, 25 Apr 2019 10:36:13 GMT ignacio_pena 2019-04-25T10:36:13Z Update existing QVD https://community.qlik.com/t5/QlikView/Update-existing-QVD/m-p/1572347#M442243 <P>Hello All,</P><P>I need some help in this.</P><P>We received a file daily with the following data</P><P>*Day 1 File</P><P>Id           Status      File_Change_Date</P><P>ABC        Initial       Jan-22-2018</P><P>* I do the following while i load my QVD with the additional columns.</P><P>Id           Status      S_Initial_Date      S_Work_In_Progress_Date      S_Completion_Date</P><P>ABC        Initial       Jan-22-2018</P><P>*Day 2 File</P><P>Id             Status                              File_Change_Date</P><P>ABC        Work In Progress             Feb-2-2018</P><P>* I do the following while i load my QVD with the additional columns.</P><P>Id           Status                      S_Initial_Date      S_Work_In_Progress_Date      S_Completion_Date</P><P>ABC        Work In Progress                                            Feb-2-2018</P><P> </P><P>*Day 3 File</P><P>Id             Status                              File_Change_Date</P><P>ABC        Complete                        March-15-2018</P><P>* I do the following while i load my QVD with the additional columns.</P><P>Id           Status                      S_Initial_Date      S_Work_In_Progress_Date      S_Completion_Date</P><P>ABC        Complete                                                                                                                March-15-2018</P><P> </P><P>Now my QVD looks like this</P><P> </P><P>Id           Status                          S_Initial_Date       S_Work_In_Progress_Date      S_Completion_Date</P><P>ABC        Initial                            Jan-22-2018</P><P>ABC        Work In Progress                                                  Feb-2-2018</P><P>ABC        Complete                                                                                                                March-15-2018</P><P> </P><P> </P><P>Question: Is there any way where i can update the qvd and looks something like this?</P><P>(Basically i want to update the status changed date to the respective coloumn when the status is changed)</P><P>Id           Status                          S_Initial_Date       S_Work_In_Progress_Date      S_Completion_Date</P><P>ABC        Complete                        Jan-22-2018                       Feb-2-2018                             March-15-2018</P> Sat, 16 Nov 2024 21:00:08 GMT https://community.qlik.com/t5/QlikView/Update-existing-QVD/m-p/1572347#M442243 Kumar6872 2024-11-16T21:00:08Z Re: Update existing QVD https://community.qlik.com/t5/QlikView/Update-existing-QVD/m-p/1573202#M442324 <P>Hello,</P><P>One idea would be to load the qvd that you currently have in 3 parts (one per day). Then you would have to join with LEFT JOIN. Finally you should export the new table in a new QVD.</P><P>I think that for the following loads, you should be able to see if you can load the QVD from days 2 and 3 with LEFT JOIN, instead of concatenating them.</P><P>I leave an example of the script.</P><P>///DAY 1<BR />DEF:<BR />LOAD Id,<BR />Status,<BR />S_Initial_Date<BR />FROM<BR />YOUR_ACTUAL_FILE.qvd<BR />(qvd) WHERE NOT ISNULL(S_Initial_Date);</P><P>//DAY 2<BR />LEFT JOIN(DEF)<BR />LOAD Id,<BR />S_Work_In_Progress_Date<BR />FROM<BR />YOUR_ACTUAL_FILE.qvd<BR />(qvd) WHERE NOT ISNULL(S_Work_In_Progress_Date);</P><P>///DAY 3<BR />LEFT JOIN(DEF)<BR />LOAD Id,<BR />S_Completion_Date<BR />FROM<BR />YOUR_ACTUAL_FILE.qvd<BR />(qvd) WHERE NOT ISNULL(S_Completion_Date);</P><P><BR />NoConcatenate<BR />DEF_OK:<BR />LOAD<BR />Id,<BR />IF(NOT ISNULL(S_Completion_Date), 'Complete', IF(NOT ISNULL(S_Work_In_Progress_Date), 'Work In Progress', 'Initial')) AS Status,<BR />S_Initial_Date,<BR />S_Work_In_Progress_Date,<BR />S_Completion_Date<BR />FROM DEF;</P><P>DROP TABLE DEF;</P><P>store * from DEF_OK into FINAL.qvd</P><P>a greeting</P><P> </P><P> </P><P> </P><P> </P> Thu, 25 Apr 2019 10:36:13 GMT https://community.qlik.com/t5/QlikView/Update-existing-QVD/m-p/1573202#M442324 ignacio_pena 2019-04-25T10:36:13Z