topic Re: NoConcatenate in load statement with QVD data source in QlikView

NoConcatenate in load statement with QVD data source

Black_Hole — Sat, 16 Nov 2024 20:40:57 GMT

Hello All,

I meet an odd isssue with the NoConcatenate function.

I have in my script two tables from QVD files. In these two tables, there are some variables with the same name.

But I don't want to define as key the variables with a name in common between the two tables.

That's why, I used the NoConcatenate function in the load statement for the two tables.

The syntax of my script is like below:

Table1:

NoConcatenate

Load * From QVD1 (qvd);

Table2:

NoConcatenate

Load * From QVD2 (qvd);

Then, after to launch my script, I noticed that my NoConcatenate was not considered.

Please could you help me to resolve my problem.

Thank you in advance for your help.

Re: NoConcatenate in load statement with QVD data source

atoz1158 — Wed, 12 Jun 2019 16:20:53 GMT

NoConcatenate is to stop Qlikview merging the from more than one source into the same table it does no stop Qlikview linking the two tables together by their common named fields.

To stop Qlikview linking either rename the fields common to two tables or use the Qualify statement for those fields.

Regards

Adrian

Re: NoConcatenate in load statement with QVD data source

rwunderlich — Wed, 12 Jun 2019 19:41:32 GMT

I think perhaps in this case you want to use "Concatenate" to create a single output table.

-Rob

Re: NoConcatenate in load statement with QVD data source

Black_Hole — Thu, 13 Jun 2019 10:10:42 GMT

Hello @atoz1158 , @rwunderlich ,

Thank both of you for your help.

In order to avoid a confusion, I added a suffix identified the table for each name of my variables.

Kind Regards