Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I need to create a data to every period, each one include 12 months backwards. To do that I'm left joining different tables, and I need to drop them after the join so when I charge all the tables created it will be only one. The problem is that when I charge the script, to drop the tables qlikview doesn't read the name of these, why is that happening?
The problem is with the table 'VOLUMEN'. Thanks
Hi,
you are adding a left join statement before the VOLUME table definition
This happens because the join is being consider above the table definition so the table volume is never created.
If you want to separate tables you must remove the join statement and add the noconcatenate.
Hope this helps.
Kind regards,
If you join table b with table a then afterwards table b does not exist. The data from table b is added to table a.
Sorry, I do not understand well, is the left join what other users say
Hi all,
I am moving this thread to the QlikView Scripting space, as it makes more sense there and will receive more visibility.
Best regards,
Qlik Community Team
Hi,
you are adding a left join statement before the VOLUME table definition
This happens because the join is being consider above the table definition so the table volume is never created.
If you want to separate tables you must remove the join statement and add the noconcatenate.
Hope this helps.
Kind regards,
Yes Im using left join with the tables but qlikview doesn't read the name of the table to drop it.