Hierarchy

[lakshmittpd]

Hi All,

Please find the below tables for my requirement.

let me know how I can achieve in Qliksense.

This is DB table

Diagram Number	Diagram Name
1.1	A
1.2	B
1.3	C
1.4	D
1.10	E
1.11	F
1.1.1	G
1.1.2	H
1.1.11	I
1.2.1	J
1.2.5	K
1.2.15	L
1.10.1	M
1.10.10	N
1.11.1	O
1.11.5	P
1.11.20	Q

Output table should be 

Level 1	level2
A	G
A	H
A	I
B	J
B	K
B	L
E	M
E	N
F	O
F	P
F	Q

with this level 1 and level 2 I need to create hierarchy.