Hello Guys
I have an excel structure like this :
Field One Field Two
256836 | ........113578.524113.115256.256836 |
N38402 | .......113578.524113.115256.256836.N38402 |
N61755 | .......113578.524113.115256.256836.N61755 |
N89028 | .......113578.524113.115256.256836.N89028 |
N00674 | .......113578.524113.115256.256836.N00674 |
N14190 | .......113578.524113.115256.256836.N14190 |
191429 | .......113578.524113.115256.256836.191429 |
N40602 | .......113578.524113.115256.256836.N40602 |
If you see the 255836 is the parent of all the other fields
So I need for example when i select in Qlik the 255836 i will have directly a new field with his sons :
Something like this :
255836 ----> N38402
N61755
N61755
N89028
N00674
N14190
191429
N40602
(This is just an example I need to Apply that for others examples (if there is a value in the right of the Field One he is his son ))
Thank you