Extract rows between a given range of Records
- 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 All,
I am trying to build a workflow to extract only certain rows of data, as the others are not required. I have a range within which the rows have to be extracted. The number of rows to be extracted between this range might vary. I was unable to do so or find any article helpful in the community, any help would be appreciated.
Here is the exact example:
I would need to extract data highlighted in yellow. The start of the range is Column A always contains "Attribute1" and the end of the range always contains "Grand Total" in column B. The number of rows in between this range might vary, hence I will not be able to give any specified number of rows to extract.
Thanks in advance for the help.
Regards,
Sri
- Labels:
- Common Use Cases
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Here is how you can do it.
Input:
Workflow:
1. Basically using multi-row formula tool i am creating a new column Column A (group) if column B = "Grand total" i am setting column A from above row[row-1] if not column A from same row.
2. I am filtering based on Column A (group) = Attribute 1.
Hope this helps 🙂
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator