Change Entire Filepath, Specify Columns

[CosimaS]

Hi, I'm using a Dynamic Input tool where I feed in an excel filepath and then change the entire filepath. The tab name is "Scenarios" so at the end of the filepath I have "|||Scenarios" and it's pulling the whole Scenarios tab. What if I just want it to pull the first two columns of the Scenarios tab? ie something like "|||Scenarios$A:$B". I've tried writing it a few different ways and can't figure out what syntax to use to specify columns

[gautiergodard]

Hey @CosimaS 

You are very close, try passing the following:  |||'Scenarios$A:B' at the end of your file path.

Hope this helps!