I need to get hierarcal data for my data given

[hemachandran]

My data is as given below

Data:

Load * Inline [

Parent,Child,Nodeid,Parentid

A,B,2,1

B,C,3,2

C,D,4,3

D,E,5,4

];

I need answer in the below format in straight table

Grandfather          Grandson

A                               C

B                               D

C                               E

D                              NA

As per the above data this should be a grandfather and grandson..

I am new to qlikview..Please help on this

Thanks in Advance..