Data Transformation
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi,
I'm trying to create workflow to transform data and assign levels to each records based on ownership structure. And I'm hitting roadblock when using Multi-Row Formula & Join tool and not able to proceed further
What I'm trying to achieve-
1. If there are multiple owners for a record (rows 21 from the attached excel - Sample Org Chart Data).
1.1 I need to add a row & duplicate data in columns A thru F and fill in columns G thru I with data from columns J thru L
1.2 I need to add a row & duplicate data in columns A thru F and fill in columns G thru I with data from columns M thru O this same process to repeat if there are several owners.
2. Need to assign Level/Tier to each record based on the position of the record in the org structure. (from the attached excel - Expected Result tab has this result)
3. Need to assign OwnerLevel/Tier to each record based on either "OwnedBy" or "OwnedByID" data( the (from the attached excel - Expected Result tab has this result)
Thank you!
Bharat S
- Labels:
- Transformation