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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

load two different tables with the same structure

Hello.

I have a problem that I can´t resolve.

I need to load two tables, stored in two Excel files. The two files has the same structure, with the same column names, but I need that each file be loaded in a diferent table. If I try to load the files, QW store the two files y the same table.

How can I do that without changing the columns name?

Thanks

4 Replies
kamalqlik
Partner - Specialist
Partner - Specialist

Hi,

Try to use No Concatenate

Regards

Kamal

Not applicable
Author

use the NOCONCATENATE statement between the load of the two tables. You will get a synthetic key table however because of the corresponding column names. You could use the qualify statement to set a different entity name before the column names.

so that would give:

entityA.columnX

entityA.columnY

entityB.columnX

entityB.columnY

have fun!! 🙂

swuehl
MVP
MVP

You can use NOCONCATENATE LOAD prefix, but this will create a huge synthetic key and table since QV is linking all fields with same name.

You can use a

QUALIFY *;

to fully qualify the field names (but that's similar to renaming).

Why not concatenate the two tables, and introducing another field that indicates the source of the data?

Not applicable
Author

@swuehl, that could be an elegant option, but it could also mean that each graph needs a set analysis included.

So it depends on how the data will be used.