How to extract every nth column starting with the column n

[winnoo]

Hello, 

I am new to Alteryx. I have an excel workbook and I would like to extract the value from every 4th column starting with column I. How do I go about doing that in Alteryx?  Thank you for the help!

[danilang · Accepted solution]

Hi @winnoo 

To extract every nth starting at column M use the following formula in a dynamic select tool configured to "Select via a Formula"

Mod([FieldNumber]-M,n)=0

Dan

[dho111 · Accepted solution]

I like @danilang formula. Here is another way to do it if you want to learn the tools.

[winnoo]

Thank you @danilang and @dho111. Both works and I was able to retrieve the column I needed.