topic Re: Concatenating tables in QlikView

Concatenating tables

markgraham123 — Fri, 16 Oct 2015 14:25:13 GMT

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

Re: Concatenating tables

MK_QSL — Fri, 16 Oct 2015 14:27:00 GMT

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

Also you don't need Concatenate word..

Re: Concatenating tables

Anonymous — Fri, 16 Oct 2015 14:28:44 GMT

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

Re: Concatenating tables

miguelbraga — Fri, 16 Oct 2015 14:28:47 GMT

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

Re: Concatenating tables

markgraham123 — Fri, 16 Oct 2015 14:29:06 GMT

Hi Manish,

That doesnot create any duplicates right???

Re: Concatenating tables

miguelbraga — Fri, 16 Oct 2015 14:29:45 GMT

No I guess, don't worry

Re: Concatenating tables

robert_mika — Fri, 16 Oct 2015 14:30:05 GMT

Yes you can...

Feeling Qlikngry?

How To /Missing Manual(18 articles)

Re: Concatenating tables

markgraham123 — Fri, 16 Oct 2015 14:30:18 GMT

Hi Rudolf,

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

Re: Concatenating tables

markgraham123 — Fri, 16 Oct 2015 14:31:06 GMT

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

Re: Concatenating tables

Anonymous — Fri, 16 Oct 2015 14:32:30 GMT

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

Re: Concatenating tables

jolivares — Fri, 16 Oct 2015 14:34:22 GMT

if you have two identical tables, you only have to load one after the other to concatenate in QV without express with the command "concatenate"

Your script is correct, you can even dispense the command "concatenate"

Re: Concatenating tables

miguelbraga — Fri, 16 Oct 2015 14:35:20 GMT

If there is a different key using the same date, there won't be a duplicate values For example, there can be 2 products qith 2 different ID's made in the same day

Re: Concatenating tables

rwunderlich — Fri, 16 Oct 2015 14:47:35 GMT

Concatenating does not filter duplicates. So yes, if 12/31/2013 exists (overlap) in both source tables then you will have duplicates. If you want to eliminate the duplicates, you have two choices. If every row contains unique values, you can use

LOAD DISTINCT ....

If every row contains a unique key, and that key is the identical on the duplicates, you can use the exists() function.

Load Field1, Field2, Field3 from

Table2.Qvd

WHERE NO EXISTS(Key);

-Rob

http://masterssummit.com

http://qlikviewcookbook.com