This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Dynamically 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?
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.