Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
markgraham123
Contributor II

Concatenating tables

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

Tags (2)
12 Replies
MVP
MVP

Re: Concatenating tables

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


Also you don't need Concatenate word..

hrlinder
Honored Contributor

Re: Concatenating tables

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
Valued Contributor III

Re: Concatenating tables

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
Contributor II

Re: Concatenating tables

Hi Manish,

That doesnot create any duplicates right???

miguelbraga
Valued Contributor III

Re: Concatenating tables

No I guess, don't worry

Re: Concatenating tables

Yes you can...

Feeling Qlikngry?

How To /Missing Manual(18 articles)

markgraham123
Contributor II

Re: Concatenating tables

Hi Rudolf,

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

markgraham123
Contributor II

Re: Concatenating tables

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

hrlinder
Honored Contributor

Re: Concatenating tables

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

Community Browser