Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
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
Partner

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.