Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Qlikview doesn't read a name of a table in a loop.

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?

debito.png

debito.png

debito.png

The problem is with the table 'VOLUMEN'. Thanks

1 Solution

Accepted Solutions
santiago_respane
Specialist
Specialist

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,

View solution in original post

5 Replies
Gysbert_Wassenaar

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.


talk is cheap, supply exceeds demand
Not applicable
Author

Sorry, I do not understand well, is the left join what other users say

Anonymous
Not applicable
Author

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

santiago_respane
Specialist
Specialist

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,

Not applicable
Author

Yes Im using left join with the tables but qlikview doesn't read the name of the table to drop it.