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.
Here's what I am trying to do. I have several columns (consider 2019 as 2018):
And I want to delete columns based on the current month. Today being 9 August 2018, the workflow would ideally delete the columns prior to that date, meaning 2018-03-01, 2018-04-01, 2018-05-01, 2018-06-01 and 2018-07-01.
Is it easily possible ? If the only solution is a complex one, I would gladly use it as well.
You could use the dynamic select to do this in a single tool. I prefer to use a couple of tools as the logic becomes more transparent. I would transpose all the columns and use a custom filter tool, to filter out any dates greater than today's date, then cross tab back into the original format. V2018.2 workflow attached.