Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
prasoon92
Contributor
Contributor

Need a little help on Hierarchy Load

I need to create hierarchy of Predecessor and Successor jobs using (Predecessor_ID, Successor_id, Predecessor_name, Successor_name).

but, the problem is I have Predecessor_id values in Successor_id field.

None of the Predecessor is Null and there are so many field where Predecessor and Successor id is same.

for example:

Two of the rows in the tables

Predecessor_ID Successor_id Predecessor_name Successor_name    mapping_control

55001                  55001              Extract                           Extract                     1

55001                  42569              Extract                           refresh                     2

42563  55001           refresh                        Extract                  3

42563                   22105              refresh                          Transform                4

55001                  55001              Extract                            Extract                     5

Has anybody come across such scenario?

0 Replies