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.
I am new user of Alteryx and I would like to solve not so complicated problem.
I have table with multiple dates for each id, sometimes is one date sometimes its 10 or more.
I would like to take second last date that occurs in the table or if there is only one for such id use this one.
I still have to learn how to manage dates values in alteryx, so this simple problem is complicated for me.
Could you help me?
I'd probably do the following
Here is a solution using the running total and formula tools to identify the second to last dates if there are multiple dates to an ID. Workflow attached.