Qlik Community

New to Qlik Sense

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

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
alec1982
Specialist II
Specialist II

restructure data from two columns

I have a table as follow and I want to change the structure so I can see how the data is connected. as you can see A is connected to B then B on the next line is connected C and then C on the next column is connected to D. I want to rebuild this lineage so it is a single row. any idea?

Column1         Column2

A                         B

B                         C

C                        D

x                         y

y                        z

 

Output will be as follow

Column1  Column2  Column3   Column4

A                    B                 C                   D

X                    Y                   Z

2 Replies
kaushiknsolanki

Hi what you need is the hierarchy builder. In Qlik you can achieve this using the Hierarchy function.

Here is the link for more information.

https://help.qlik.com/en-US/sense/September2020/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptPre...

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".
alec1982
Specialist II
Specialist II
Author

thank you for the help. having hard time to get the table to the structure I listed above. would appreciate if you can try it.