Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Uploads getting stuck in the virus scanner. We are investigating.
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

Combine the two columns into single column.

Hi team, I have 2 Tbales like

Column1,                  column2

Hari123 ,                  teja954

abcd123                   xyz653

mn342                      acv 11

And I want output like:

Coloumn


Hari123

abcd123

mn342

teja954

xyz653

acv 11

4 Replies
Highlighted
Partner
Partner

Hello,

You can use the concatenate function in the script to combine the two tables as you require.

outputtable:

LOAD

Column1 as newcolumn

resident table1

concatenate(outputtable)

Load

column2 as newcolumn

resident table2;

so in the outputtable you will have single column combining the data.

Highlighted
Creator II
Creator II

I have singel table only with two columns.

Highlighted
Partner
Partner

If you have a single table then you would resident the table twice. Is this what you want?

outputtable:

LOAD

Column1 as newcolumn

resident table1

concatenate(outputtable)

Load

column2 as newcolumn

resident table1;

so in the outputtable you will have single column by the name of newcolumn combining the data.

Highlighted
Specialist
Specialist

New:

Load

Col1

from table

col2

from table

or maybe this but i think first one will work

New:

Load

Col1

from table

col2 as Col1

from table