Pulling specific rows of data

[Wynn]

Hello,

Attached is the workflow and the input for my question.

I just wanted to pull the information starting on row 6 all the way till the end. Is there a way to do that instead of using the "select record" tool. I'm having multiple files with the same information. However, each workbook does not always start with the needed information on row 6 so the "select record" seems to work only for one workbook but not for the rest. Thank you so much for your help!

[fmvizcaino · Accepted solution]

Hi @Wynn ,

I've attached an example where I dynamically cut the dataset based in a condition.

Take a look and let me know if this makes sense to you.

Best,

Fernando Vizcaino

[DiegoParker · Accepted solution]

Hi Wynn,

As a starting tip, you can also put this configuration on the input tool.

Because it is not always on row 6, then I created the following apporach:

Find the example attached.

Hope this helps.

Best,

Diego

[Wynn]

@DiegoParker @fmvizcaino  Thanks so much to you both! The workflows work perfectly.