Free Trial

Alteryx Designer Desktop Discussions

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

Isolating data between two row markers dynamically

Alt_eryx22
7 - Meteor

Hello, I have some data that I'm trying to input dynamically from several different spreadsheets. I'm trying to isolate only the data between the STARTDATA and ENDDATA markers. I'd need these to be the indicator because the number of rows between the two is dynamic between the files (some have 10 rows of data and others have 40+). Any idea how to do that? I've tried a recordID and formula tool to tag out each line of data if it's greater than STARTDATA row and less than ENDDATA row, but I feel like I might be overcomplicating it. Is there a better way? Example dataset attached. Thanks in advance!

 

 

Screenshot 2024-10-09 140503.png

2 REPLIES 2
binuacs
21 - Polaris

@Alt_eryx22 one way of doing this.

Note I applied multi-row tool for only F and F2, you can do the same for the rest of the fields

image.png

nagakavyasri
12 - Quasar

@Alt_eryx22 another way of doing this:

 

Screenshot 2024-10-11 151820.png

Labels
Top Solution Authors