Here is the crazy requirement, just let me know your inputs
Input Data:
111, 100, 200,MDC
222, 200, 300, AAA--->
333, 300, 400,ABC
444, 400, 500,BCD
Ex: record BCD got changed to DCB then i have to get the 222 from navigating 500 -> 400-> 300 -> 200 ->222
Note: No SQL, everything have to do in Data stage only and records always doesn't looks like this and not always bottom to top or top to bottom everything random only
![Smile :)](./images/smilies/icon_smile.gif)
Thanks a lot in Adv