Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

The highly anticipated Alteryx Community tradition is back! We hope you'll join us!

Learn More

Dynamically select input columns


Dear friends,

Dynamically Select Date Columns.jpgDynamically Select ColumnsI want to schedule a workflow and dynamically select columns (the column headers are the last Sunday of the week). I want to run the workflow on Monday and it should fetch the data for the next week, below is my example


For example - i run the workflow on coming Monday i.e 7th Jan, it should select the column header 12th Jan and drop all the remaining columns, I then can use this column ahead for my transformation. Can you please suggest the way to do this? 


Thanking you,



Hi @rajatsaxena0707


OK, you may have to bear with me a little bit on this one, not sure it's the most simple, but it will work.


I have attached the workflow, the dynamic select is the part you want, I left the formula in there so you can see my working....




First I needed to get the week number - DateTimeFormat(DateTimeToday(),"%W")

Then I needed to times this by 7 and add this onto the first Sunday in 2019 - DateTimeAdd("2019-01-05",ToNumber([Week])*7,"days")

Lastly I then needed the date format to match that of your columns - Trim(DateTimeFormat([Date],"%d-%b"),"0")


Once I had achieved the output I rolled them all into one formula and that is what I used in the Dynamic Select:


[Name] = Trim(DateTimeFormat(DateTimeAdd("2019-01-05",ToNumber(DateTimeFormat(DateTimeToday(),"%W"))*7,"days"),"%d-%b"),"0")

Hi @JoeS


Thank you so much for providing the solution.. I was trying to accomplish this but in a different way and made it more complicated than it should have been; Your solution worked perfectly fine, thank you.





@rajatsaxena0707 you're welcome. I did quickly check a few random Monday's in the future, I think the time it may fall down/need updating is the start of 2020.