Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Extract rows between a given range of Records

Sriharsha-3134
6 - Meteoroid

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:

 

Selected Range modified.png  

 

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

 

3 REPLIES 3
atcodedog05
22 - Nova
22 - Nova

Hi @Sriharsha-3134 

 

Here is how you can do it.

 

Input:

atcodedog05_0-1621938721807.png

Workflow:

atcodedog05_1-1621938752173.png

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 ðŸ™‚

 

KarolinaRoza
11 - Bolide

Hi,

 

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

 

KarolinaRoza_0-1621939247758.png

 

 

Regards,

Karolina

 

mceleavey
17 - Castor
17 - Castor

Hi @Sriharsha-3134 ,

 

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

 

mceleavey_0-1621939781638.png

 

mceleavey_1-1621939817797.png

 

 



Bulien

Labels
Top Solution Authors