Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
ID | Name | Previous ID | Complete |
---|---|---|---|
1 | Person 1 | No | |
2 | Person 2 | 1 | No |
3 | Person 3 | No | |
4 | Person 4 | 3 | Yes |
5 | Person 5 | 2 | No |
6 | Person 6 | 5 | Yes |
I need to add a column called Original ID which will look like below. Any thoughts?
ID | Name | Previous ID | Complete | Original ID |
---|---|---|---|---|
1 | Person 1 | No | 1 | |
2 | Person 2 | 1 | No | 1 |
3 | Person 3 | No | 3 | |
4 | Person 4 | 3 | Yes | 3 |
5 | Person 5 | 2 | No | 1 |
6 | Person 6 | 5 | Yes | 1 |
This can be achieved using Hierarchy function. Please refer attached sample application.
Regards!
Rahul Pawar
What was the logic behind? that may helps you
how the original id column defined from? what is the caluclation ?
I don't have access to the logic but it looks to be incremental rows. No set order or logic that I can use to link. I'm thinking that this is going to require multiple FOR loops.
This can be achieved using Hierarchy function. Please refer attached sample application.
Regards!
Rahul Pawar
I created a hierarchy and joined it to my table using the ID fields and brought in the new field which was the top position from the hierarchy.
Thanks!
Cheers!
Rahul Pawar