4 Replies Latest reply: May 2, 2017 1:06 AM by Marcus Sommer RSS

    How can I save the variable names of a list of QVD's, and then use left join (with null values), the objective is to have all the QVD's with the same variables.

    Fernando Mercado

      Hi,

       

      Now I'm working in a loop, extracting data of old periods and creating a resume of the information of clients. But this information it's not always available so I use Set Error to avoid stop the script, with this Set Error the variables doesn't exist, so when I load the different QVD's of different periods, in some cases Qlikview doesn't open the period in the same table (when some variable is missing) so I want to storage all the variable names of all the periods to then, use left join with null values so if the variable exists nothing happens and if it's not, it will be a empty variable, but it will read all the periods in the same table, please help.

       

      Thanks.