Extract rows between a given range of Records

Question

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

mceleavey · Answer

Hi @Sriharsha-3134 ,

In addition to my fine cohorts here, here's yet another way, just for giggles:

mceleavey_solution.yxmd

KarolinaRoza · Answer

Hi,

You can apply Multi-row formula tool to identify which rows do you want to extract which do not:

Regards,

Karolina

Extract rows.yxmd

atcodedog05 · Answer

Hi @Sriharsha-3134

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 🙂

attribute A.yxmd