topic Re: Concatenate two tables in QlikView

Concatenate two tables

Tue, 21 May 2013 10:09:16 GMT

Hi,

I have a table with 3028 rows and 65 columns (fields).

For some reason I need to load 3028 rows and 4 columns first, and then, add the same for the other 61 columns so at the end I need to have the original table (3028 x 65) loaded.

I tried JOIN LOAD and it multiplies the resulting rows in millions, I tried CONCATENATE it multiplies the resulting rows by 2, ...

I think must exist a simple command to do that simple task.

Thanks.

Re: Concatenate two tables

kumarnatarajan — Tue, 21 May 2013 10:13:03 GMT

Hi,

It is fact one. you will try to left join with some Mapping(Unique) fields.

Re: Concatenate two tables

Tue, 21 May 2013 10:14:08 GMT

use LEFT KEEP

or try with WHERE condition

Re: Concatenate two tables

sushil353 — Tue, 21 May 2013 10:18:18 GMT

Hi,

Try this sample:

tab1:

load *,RecNo() as flag inline [

Name,Amount

John,-22

John,10

John,12

Mike,-10

Mike,5

];

join(tab1)

load *,recno() as flag Inline

[

test

];

put an extra field called flag in both load with function recno().

HTH

Sushil

Re: Concatenate two tables

Tue, 21 May 2013 10:35:32 GMT

Unfortunately there is no mapping fields, the question is as simple as paste a table previously cutted in two:

Re: Concatenate two tables

kumarnatarajan — Tue, 21 May 2013 10:53:08 GMT

Hi,

See the sushil kumar syntex:

T1:

Load *,RowNo() as Key from T1File;

left join(T2)

Load *,RowNo() as Key from T2File;

Now RowNo() as Key this is mapping field. So now it is possible

Re: Concatenate two tables

sushil353 — Tue, 21 May 2013 10:53:22 GMT

could you provide some sample data.. say first 5 field and then 4-5 additional field..

Re: Concatenate two tables

Thu, 23 May 2013 13:38:31 GMT

It is allready solve, it was a question of using some common fields and an ordinary join load.

Thank you