merging two tables with the same fields

[#1]

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 )

[tresesco]

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

[#3]

Ok thank you but with the same name?

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

[ashfaq_haseeb]

Hi

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

[tresesco]

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

[its_anandrjs]

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;

[#7]

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?

[ashfaq_haseeb]

Hi,

You can try with binary load for your source table.

Regards

ASHFAQ

[its_anandrjs]

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