SOLVED
Creating a "parent" node
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Javier070590
7 - Meteor
‎01-22-2022
10:11 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Dear Community,
I would appreciate your help. I am trying to assign a "parent" node for organization structure I have.
I have columns ORGANIZATION and LEVEL, I need to create Parent column. I tried multi row formula but it doesn't work.
ORGANIZATION | LEVEL | Parent |
Name1 | 1 | 0 |
Name2 | 2 | Name1 |
Name3 | 2 | Name1 |
Name4 | 2 | Name1 |
Name5 | 3 | Name4 |
Name6 | 3 | Name4 |
Name7 | 2 | Name1 |
Name8 | 3 | Name7 |
Name9 | 2 | Name1 |
Name10 | 2 | Name1 |
Name11 | 1 | 0 |
Name12 | 2 | Name11 |
Name13 | 2 | Name11 |
Name14 | 3 | Name13 |
Name15 | 4 | Name14 |
Name16 | 4 | Name14 |
Name17 | 3 | Name13 |
Name18 | 2 | Name11 |
Thank you in advance,
Marcin
Solved! Go to Solution.
Labels:
- Labels:
- Preparation
- Transformation
5 REPLIES 5
22 - Nova
‎01-22-2022
10:28 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎01-23-2022
12:46 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @atcodedog05,
Thank you for your feedback, it looks very interesting, however still doesn't work perfectly. In yellow I highlighted output different that expected:
Parent column:
Line 8 should be Name 7 (instead of Name4)
Line 12 and Line 13 should be Name11 (instead of Name1)
Line 14 should be Name13 (instead of Name4)
Do you have any idea?
Thank you,
Marcin
22 - Nova
‎01-23-2022
01:12 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎01-23-2022
05:06 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
22 - Nova
‎01-23-2022
05:07 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Happy to help : ) @Javier070590
Cheers and have a nice day!
