Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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
Valued Contributor

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

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,

5 Replies

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

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

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

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

Community Manager
Community Manager

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

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
Valued Contributor

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

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

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

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

Community Browser