topic Re: Combine table in qlik in QlikView

Combine table in qlik

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

I need to combine between 3 tables as bellow:

SQL SELECT

"ACTNUMBR_1" & "ACTNUMBR_2" & "ACTNUMBR_3" As "ACCTNUMB"

FROM CTRA.dbo.GL00201;

to got this result:

Re: Combine table in qlik

Chanty4u — Tue, 12 Apr 2016 10:29:01 GMT

is this?

ACTNUMBR_1 &'_' ACTNUMBR_2 & ' _' ACTNUMBR_3 As ACCTNUMB

Re: Combine table in qlik

sujeetsingh — Tue, 12 Apr 2016 10:32:36 GMT

Add a key as

TabFinal:

,Rownum() as Key

ACTNUMBR_1

from table1;

join

,Rownum() as Key

,ACTNUMBR_2

from table2;

join

,Rownum() as Key

,ACTNUMBR_3

from table3;

CombinedData:

Key,

ACTNUMBR_1 & '-'& ACTNUMBR_2 &'-'& ACTNUMBR_3

from TabFinal;

Drop table TabFinal;

Re: Combine table in qlik

Kushal_Chawda — Tue, 12 Apr 2016 10:33:01 GMT

perhaps like below

LOAD *,

ACTNUMBR_1 &'-' &ACTNUMBR_2 & '-' &ACTNUMBR_3 As ACCTNUMB ;

SQL SELECT *

FROM CTRA.dbo.GL00201;

Re: Combine table in qlik

Anonymous — Tue, 12 Apr 2016 10:35:46 GMT

do you want to concatenate field from the same table or different table?

Re: Combine table in qlik

sunny_talwar — Tue, 12 Apr 2016 10:40:36 GMT

May be this:

Table:

LOAD RowNo() as Key,

ACTNUMBR_2;

SQL SELECT

"ACTNUMBR_2"

FROM CTRA.dbo.GL00201;

Join (Table)

LOAD RowNo() as Key,

ACTNUMBR_3;

SQL SELECT

"ACTNUMBR_3"

FROM CTRA.dbo.GL00201;

Join (Table)

LOAD ACTNUMBR_1;

SQL SELECT

"ACTNUMBR_1"

FROM CTRA.dbo.GL00201;

FinalTable:

LOAD ACTNUMBR_1 & '-' & ACTNUMBR_2 & '-' & ACTNUMBR_3 as ACCTNUMB

Resident Table;

DROP Table Table;

Re: Combine table in qlik

maniram23 — Tue, 12 Apr 2016 11:00:53 GMT

Table:

LOAD RowNo() as Key,

ACTNUMBR_2;

SQL SELECT

"ACTNUMBR_2"

FROM CTRA.dbo.GL00201;

Join (Table)

LOAD RowNo() as Key,

ACTNUMBR_3;

SQL SELECT

"ACTNUMBR_3"

FROM CTRA.dbo.GL00201;

Join (Table)

LOAD

LOAD RowNo() as Key,

LEFT ( 0000 & ACTNUMBR_1 , 2 ) as ACTNUMBER_1;

SQL SELECT

"ACTNUMBR_1"

FROM CTRA.dbo.GL00201;

FinalTable:

LOAD ACTNUMBR_1 & '-' & ACTNUMBR_2 & '-' & ACTNUMBR_3 as ACCTNUMB

Resident Table;

DROP Table Table;