merge multiple column into one column

[raji6763]

hi

i have a table below

i want to merge the columns into one column

expected output:

regards,

raji

[Or]

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

[raji6763]

is there any other way?

[Or]

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.

[raji6763]

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

[Saravanan_Desingh]

Check this solution.

https://community.qlik.com/t5/New-to-Qlik-Sense/Update-New-Folder-Data/m-p/1724689#M167077