Concatenating tables

[markgraham123]

Hi all,

I have 2 tables with same no. of fields and field names.

Table 1 contains the data of 2014 year.

Table 2 contains the data of 2013 year.

Can i use the below code to combine both into single table????

Table3:

Load Field1, Field2, Field3 from

Table1.Qvd;

Concatenate

Load Field1, Field2, Field3 from

Table2.Qvd;

Store Table3 into 2013&2014 Data.qvd

[MK_QSL]

Store Table3 into '2013&2014 Data.qvd'(QVD);

Also you don't need Concatenate word..

[Anonymous]

yes you can do that

but you will loose the year Information, so add the year as well

Table3:

load Field1, Field2, Field3, '2014' as Year from

Table1.Qvd;

concatenate (Table3)

load

Field1, Field2, Field3, '2013' as Year from

Table2.Qvd;

Store Table3 into 2013&2014 Data.qvd

[miguelbraga]

If you have the same fields in both tables, then you can remove the concatenate Those two tables will automatically join one another if they have exactly the same fields

[markgraham123]

Hi Manish,

That doesnot create any duplicates right???

[miguelbraga]

No I guess, don't worry

[robert_mika]

Yes you can...

Feeling Qlikngry?

How To /Missing Manual(18 articles)

[markgraham123]

Hi Rudolf,

I was wondering if there is 12/31/2013 in both the tables, will it cause any dupliocates???

[markgraham123]

I was wondering if there is 12/31/2013 in both the tables, will it cause any duplicates???

[Anonymous]

I know that you donot Need the keyword "concatenate" as it's done automatically by qlikview

I prefer to write it down anyway. If you look at your script it is clear what happens

especially if the previous table is not immediate before the table to concatenate

this depends on you