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.
We have extended our Early Bird Tickets for Inspire 2023! Discounted pricing goes until February 24th. Save your spot!
I have Data like below, Date is is (MM/DD/YYY-Format)
I want the output as below,
Hi Community, Please Help me in achieving this.
You could use the multi-row formula tool to achieve this. Here's an example:
I converted the date to ensure that the data is always sorted properly. Then it's a simple matter of taking the row-1 value for each item using the multi-row formula's group-by function.
Instead the Data template I posted above consider the data template below, the solution required is same.
Date in MM/DD/YYYY format
Have you tried the solution I posted? I believe it should work (or be easily adaptable) in your workflow. Can you share your workflow and I can help you troubleshoot? That will help you best learn.
Here's an alternative version using a join rather than multi-row formula, applied to both data sets.
Hey yeah tried your solution didn't worked out, Actually I can't share the workflow due to data reasons.