Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Error with LOAD sentence

Hello,

I'm having problems on load Files.

I have a function that:

1. Load a qdv file

TABLENAME << x Records

2. For each txt file do ...

Here is where I have the problem.

After LOAD I have writed table name to load. TABLENAME_2 (It's an example), but when the system loads, it's writing records on qvd tablename, that has the same structure that tablename_2.

TABLENAME_2:

LOAD

...

I get TABLENAME << x+new one records. and I want TABLENAME_2 << x records

I don't want to load data on tablename, I want to load it on TABLENAME_2.

Can someone help me

1 Solution

Accepted Solutions
vupen
Partner - Creator
Partner - Creator

When 2 tables that have same column structure are loaded, QV automatically joins the second into the first table.

To avoid it, use the directive [no concatenate] telling QV not to concatenate.

Ex:


TABLE_1:
Load
Select *
From
TABLE_1.qvd (qvd);
TABLE_2:
NoConcatenate Load
Select *
From
TABLE_2.qvd (qvd);



View solution in original post

3 Replies
Not applicable
Author

Do you have code that you can show?

vupen
Partner - Creator
Partner - Creator

When 2 tables that have same column structure are loaded, QV automatically joins the second into the first table.

To avoid it, use the directive [no concatenate] telling QV not to concatenate.

Ex:


TABLE_1:
Load
Select *
From
TABLE_1.qvd (qvd);
TABLE_2:
NoConcatenate Load
Select *
From
TABLE_2.qvd (qvd);



d_pranskus
Partner - Creator III
Partner - Creator III

You should use following syntax:


TABLE_1:
Load *
From TABLE_1.qvd (qvd);
TABLE_2:
NoConcatenate Load *
From TABLE_2.qvd (qvd);