Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Folks,
I'd like to know your inputs on how to create a hierarchy from one source file without using too many tHashInputs as a lookup. See requirements and expected output below:
Input
|Emp Name | Emp Id | Manager Id|
|--------------------------------------------------|
|Jerome Sare | JNS12 | MR13 |
|Madey Den | MR13 | MB14 |
|Mike Bick | MB14 | TS15 |
|Trevlin Sucre | TS15 | DS16 |
|Dicker Sipeds | DS16 | VS17 |
|Vander Sicken | VS17 | VS17 |
Expected Output
Emp Name | CEO_LVL1 | CEO_LVL2 | CEO_LVL3 | CEO_LVL4
-------------------------------------------------------------------------------------------------
Jerome Sare | Vander Sicken | Dicker Sipeds | Trevlin Sucre | Mike Bick
Madey Den | Vander Sicken | Dicker Sipeds | Trevlin Sucre | Mike Bick
Mike Bick | Vander Sicken | Dicker Sipeds | Trevlin Sucre |
Trevlin Sucre | Vander Sicken | Dicker Sipeds | |
Dicker Sipeds | Vander Sicken | | |
Vander Sicken | Vander Sicken | | |
CEO_LVL1 = Emp Id is equal to manager Id that will be CEO_LVL1, then it will traverse down up to 4 levels to get the CEO_LVL2 - CEO_LVL4.
Let me know your thoughts on this.
Thank you.
Here's the sample file and talend job that I modified based on the attachment you've provide.
Thank you very much.
Thank you @uganesh, I tried executing the job and it doesn't go into loop like the ones you've provided me before. I'm currently in-progress with troubleshooting..Please advise.
Thank you so much!
@uganesh Can you please help me with https://community.talend.com/t5/Data-Quality-Preparation-and/Employee-Hierarchy-using-talend/td-p/16...