topic Re: merging two tables with the same fields in QlikView

merging two tables with the same fields

Wed, 11 Jun 2014 07:26:36 GMT

Hello everybody,

I have a problem with two tables . In fact i have two tables in two files differents

but they have exactly the same fields:

Adresse

Number

Name

etc..

I'd like to have the second table below the first, to make a fusion so.. how it is possible?

Thank you (and sorry for my english )

Re: merging two tables with the same fields

tresB — Wed, 11 Jun 2014 07:28:06 GMT

Load them one after another, qv would automatically concatenate them. Like:

MergedTable:

Load

From <Source1>;

Load

From <Source2>;

Now you would get a single table named as labelled 'MergedTable' .

Re: merging two tables with the same fields

Wed, 11 Jun 2014 07:29:07 GMT

Ok thank you but with the same name?

How can i load a table which is in an other file?

Re: merging two tables with the same fields

ashfaq_haseeb — Wed, 11 Jun 2014 07:30:20 GMT

you can do something like below

Table1:

load

Adresse,

Number,

Name,

from abc;

concatenat

load

Adresse,

Number,

Name,

from xyz;

can you post a sample if possible?

Regards

ASHFAQ

Re: merging two tables with the same fields

tresB — Wed, 11 Jun 2014 07:31:32 GMT

Yes, with same name, and it has to be all same.

Re: merging two tables with the same fields

its_anandrjs — Wed, 11 Jun 2014 07:45:08 GMT

Load this tables and in qlikview they concatenate to each other because having same field name or you can put the Table flag also to identify the rows of the table

Load

Adresse,

Number,

Name,

'Table2' as TableFlag

From Table1;

Load

Adresse,

Number,

Name,

'Table1' as TableFlag

From Table2;

Re: merging two tables with the same fields

Wed, 11 Jun 2014 07:54:28 GMT

Thank you all, but how can i find the source from my table2 because it is on an other qlikview document..

ok for table1

margingtable:

load * from table1;

load* from \\test.qvw.table2?

Re: merging two tables with the same fields

ashfaq_haseeb — Wed, 11 Jun 2014 07:56:10 GMT

Hi,

You can try with binary load for your source table.

Regards

ASHFAQ

Re: merging two tables with the same fields

its_anandrjs — Wed, 11 Jun 2014 07:57:04 GMT

No problem if you have same fields then they concatenated where ever it has different source.