Entry No. is a unique Number. Entry nos 1 to 3 are staring numbers, the balance are linked numbers,. for eg. entry no 8 is linked to 7 which in turn is linked to 4, which in turn is linked to 1. Because there is no reference against 1, it is the the starting number
i wanted the results as below:
For entry no. 8, the links end at entry no. 1 and corresponding reference against 1 is AAA.
i got the output as required in the attachment.
Now i have made a small change.
in the above table, for entry 5 and 6, the reference number is the same.
Now can anyone provide the answers in qliksense file