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

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?

Sample file.xlsx

Datasets

Accepted answers

alexnajm

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

How to pull the last 3 columns from an accumulative file.yxzp

All comments

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