Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Kohli
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
sjhussain
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.

Kohli
Creator II
Creator II
Author

I have singel table only with two columns.

sjhussain
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.

zebhashmi
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