Select the input data from the middle of the source file

[cterrence]

Hi All

I have a source file with two sections 

a.  One section is with ABC company

b. Second section is with XYZ company

I want the input data only from XYX company

How do I use input data or any other tools to select the data from XYZ and ignore the first section i.e ABC company ?

Please note that the data for XYZ can start at any part of the source file

Thanks for helping

Regards

[apathetichell]

This is not possible with a .csv file. You have to read in all of the information and then select only the information you want.

[gaoa]

Hi @cterrence I agree with @apathetichell it's easiest to use Input Data tool and then select the data you want using Select Records tool to select data ad hoc basis since you mentioned the data for XYZ can start at any part of the source file. If there is a way to determine which rows to select by logic, then a Filter tool will be useful.

FYI: to bring in only part of the data sheet using Input Data tool, the input file needs to be in Excel format and the cell range to be fixed.

In this example, the file path will be:

.\sample.xlsx|||'data$A5:G7'

Hope this helps.

[cterrence]

Thank you

[markcurry · Accepted solution]

Hi @cterrence , you can use the Multi-Row Formula tool to identify each company name by searching for 'Account Name:' in the first field.  Then you can filter for "XYZ".  See the attached workflow, hope that helps.