topic Re: load two different tables with the same structure in QlikView

load two different tables with the same structure

Thu, 18 Oct 2012 09:48:42 GMT

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

Re: load two different tables with the same structure

kamalqlik — Thu, 18 Oct 2012 09:51:45 GMT

Hi,

Try to use No Concatenate

Regards

Kamal

Re: load two different tables with the same structure

Thu, 18 Oct 2012 09:52:27 GMT

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!! 🙂

Re: load two different tables with the same structure

swuehl — Thu, 18 Oct 2012 09:53:42 GMT

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?

Re: load two different tables with the same structure

Thu, 18 Oct 2012 09:55:43 GMT

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