Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi
i have a table below
i want to merge the columns into one column
expected output:
regards,
raji
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...
is there any other way?
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.
Thank you for you answer.i got the output using concatenate. i tried the scenario using cross table. i did not get expected output