load two different tables with the same structure

[#1]

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

[kamalqlik]

Hi,

Try to use No Concatenate

Regards

Kamal

[#3]

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]

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?

[#5]

@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.