Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
This question is Not Answered.(Mark as assumed answered)
zebhashmi Dec 20, 2017 9:56 AM
ID | Father name | Name |
1 | A | |
2 | 1 | B |
By selecting 2 want to display its Father Name which is A in this Example.
SampleData:
LOAD * Inline [
tmpID, tmpFatherName, tmpName
1, , A
2, 1, B
3, 2, C
];
mapaFather:
Mapping LOAD
tmpID,
tmpName
Resident
SampleData;
data:
LOAD
tmpID as ID,
ApplyMap('mapaFather', tmpFatherName) as FatherName,
tmpName as Name
Resident
SampleData;
DROP Tables SampleData;
or you can use hierarchy
Thank you but i can't do that in script as i have may felid in there want to do it in expression
Regards
JH
Hi,
Please see if this is what you're after
I hope it helps,
Thank you very much!