Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
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