Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

merge multiple column into one column

hi

i have a table below

raji6763_0-1593514550573.png

i want to merge the columns into one column

expected output:

raji6763_1-1593514659286.png

regards,

raji

5 Replies
Highlighted
Specialist III
Specialist III

Re: merge multiple column into one column

Load F_Name, active, F_flage, C_Name1 as C_Name, C_Role1 as C_Role, C_Loc1 as C_Loc

From Table;

Concatenate

Load

Load F_Name, active, F_flage, C_Name2 as C_Name, C_Role2 as C_Role, C_Loc2 as C_Loc

From Table;

etc.

 

If your list of fields is very long, consider using Unpivot instead. https://help.qlik.com/en-US/sense/June2020/Subsystems/Hub/Content/Sense_Hub/LoadData/work-with-cross...

 

Highlighted
Creator
Creator

Re: merge multiple column into one column

is there any other way?

Highlighted
Specialist III
Specialist III

Re: merge multiple column into one column

There are probably ways other than these two, but since each of these two ways should work for your described use case, I see no reason to seek them out... if you have requirements that weren't mentioned in your original post, you should probably be specific as to what they are to allow more specific answers.

Highlighted
Creator
Creator

Re: merge multiple column into one column

Thank you for you answer.i got the output using  concatenate. i tried the scenario using cross table. i did not get expected output

Highlighted
Specialist III
Specialist III

Re: merge multiple column into one column