topic Concatenate Tables in QlikView

Concatenate Tables

Tue, 18 Apr 2017 13:07:43 GMT

I have two tables, from File 1 and File 2, with the same columns. They are currently concatenated into the same table.

However, I would also like to add a column with a 0 or 1 value to distinguish those from File1 and from File2. Any help with this would also be much appreciated.

Thanks very much!!

Re: Concatenate Tables

jrepucci15 — Tue, 18 Apr 2017 13:26:38 GMT

What loads are you trying to concatenate? You show three loads, but only one table name and there are no concatenate keywords in the 2nd / 3rd loads.

It appears you are missing a FROM statement for table Fruits1

There is a double comma following [Name1]

To distinguish the different source files, I typically add a statement to each load such as this:

'Fruits1" AS Source,

'File1' AS Source,

'File2' AS Source

Re: Concatenate Tables

OmarBenSalem — Tue, 18 Apr 2017 13:30:56 GMT

TableFinale:

load

*, 'Table1' as NewField

From sourceTable1;

concatenante // or don't, they automatically be

load

*, 'Table2' as NewField

From sourceTable2;

With that, we create a new field in each table to distinguish.

Hope this helps

Re: Concatenate Tables

Tue, 18 Apr 2017 14:02:52 GMT

Hi Omar,

How would i make the new field in each table in order to distinguish them? I would like to be able to put a 0 vs a 1 to distinguish rows in file1 from file2

Re: Concatenate Tables

OmarBenSalem — Tue, 18 Apr 2017 14:05:21 GMT

0 is rows from table 1 and 1 are rows from table 2?

TableFinale:

load

*, '0' as NewField

From sourceTable1;

concatenante // or don't, they automatically be

load

*, '1' as NewField

From sourceTable2;