How to pull the last 3 columns from an accumulative file(excel)

[cl1818]

I am using an .xlsx Excel spreadsheet as input in my workflow. The issue is the spreadsheet contains over 100 plus columns and each quarter 3 additional columns will be added. I only need the first 6 columns and the last 3 columns. Is there a way to only pull in the columns of the spreadsheet you need for your workflow?

[alexnajm]

Yes, a Dynamic Select tool can be used! [FieldNumber]<=6 will work to grab the first 6 columns

The last 3 is a bit trickier - you can use a FieldInfo tool, count the number of rows with a Summarize, Append Fields to the original data, and use that in your Dynamic Select as a variable

[alexnajm · Accepted solution]

I misspoke - you can't reference other columns in a Dynamic Select. So I'd do this:

[cl1818]

Thank you so much for your help!

[alexnajm]

Fantastic - please accept my response as a solution then. Thanks in advance!

[flying008]

Hi, @cl1818 

Another way for you to get first 3 columns and last 3 columns.

[cl1818]

Thank you!