Combine table in qlik

[Anonymous]

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:

[Chanty4u]

is this?

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

[sujeetsingh]

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;

[Kushal_Chawda · Accepted solution]

perhaps like below

LOAD *,

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

SQL SELECT *

FROM CTRA.dbo.GL00201;

[Anonymous]

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

[sunny_talwar]

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;

[maniram23]

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;