Is there any option to try a Dynamic Sample Tool?

Hi everyone,

I am in a workflow where my input are more than 120 excel files so I used Directory tool for that. My problem is that I need all the data from each excel file since its row 72. But when I use Sample Tool it only filter the first 71 rows, but this does not replicate in every single file so I get data that I don´t need. I would like to know if it is possible to make this happen.

Thanks in advance!

Developer

Accepted answers

messi007

Hello,

You can use a dynamic read and specify from which column you need to start importing data (72 in your case) instead of a sample tool:

Below as an example I started importing data from row 14.

Attached the workflow,

Hope this helps,

Regards

ReadFiles_20210511.yxmd

All comments

messi007

Hello,

You can use a dynamic read and specify from which column you need to start importing data (72 in your case) instead of a sample tool:

Below as an example I started importing data from row 14.

Attached the workflow,

Hope this helps,

Regards

ReadFiles_20210511.yxmd

JoseMignone

Thank you very much, that was very helpful!!! You even answered me other doubt that I had on mind.

Best Regards!

JoseMignone

Hello,

I am sorry, but in case I want to do this same thing but the other way around? I mean, I would like to delete lines from the end of each file. Filter Tool is not an option because there are some lines that have the same data of the lines which I do need.

Thanks (again) in advance!

Quick Links

This months top contributors

SophiaF 432

AkimasaKajitani 390

mceleavey 388

mbarone 337

michael_weaver 335