topic Re: Concatenate in QlikView

Concatenate

deepakqlikview_123 — Wed, 14 May 2014 06:54:31 GMT

If thwo tables having completely different structure(No field is comman).In this case qlikview will concatenate the two tables.

And why joining needs atleast one field is comman in between two tables.

Thanks,

Deepak

Re: Concatenate

sushil353 — Wed, 14 May 2014 06:57:31 GMT

Hi Deepak,

You can concatenate any two tables using concatenate keyword..

If you want to join two table then there should be one field common in two table based on which it get joined other wise you will get a cross product of two tables.

HTH

Sushil

Re: Concatenate

varunjain — Wed, 14 May 2014 06:59:01 GMT

Hi,

Because concatenate does not consider the common fields and simply append the second table below the first one.

Where as join is used when there is a relation between the two tables.

there fore if you have two tables with no column in common then there is no sense in JOINING them but even after that you dont want to view them as two differnet tables then it is best to conactenate them and view both the columns in a single table.

Re: Concatenate

alexandros17 — Wed, 14 May 2014 06:59:13 GMT

concatenate will put null values for fields belonging to ine table and not present in the other, join does not need a commom field, if so join computes all possible combination of fields (very slow)

Hope it helps

Re: Concatenate

jagan — Wed, 14 May 2014 07:01:48 GMT

Hi,

If none of the column is common in both the tables then also you can concatenate the tables like this

data:

LOAD

Field1

FROM DataSource1;

Concatenate(data)

LOAD

Field2

FROM DataSource2;

For DataSource1 data Field2 values are null and For DataSource2 data Field1 values are null.

For joining we need the key field in two tables, if not then the result table will be a cartesian product.., you will get more records ie., duplicate records.

Regards,

Jagan.