topic Re: Multirow formula to identify the wave in Alteryx Designer Desktop Discussions https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Multirow-formula-to-identify-the-wave/m-p/1316257#M328331 <P><a href="https://community.alteryx.com/t5/user/viewprofilepage/user-id/456897">@Cherub7210</a>&nbsp;can you explain the logic?</P> Mon, 09 Sep 2024 10:28:41 GMT binu_acs 2024-09-09T10:28:41Z Multirow formula to identify the wave https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Multirow-formula-to-identify-the-wave/m-p/1316242#M328327 <P>How would i use the multirow formula to identify wave 1, 2, 3 using the due on date? Below is the example</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>Output: Wave identifier</TD></TR><TR><TD>106751</TD><TD>Action item 2</TD><TD>Deployment</TD><TD>10/31/2024</TD><TD>Wave 2</TD></TR><TR><TD>106751</TD><TD>Action item 1</TD><TD>Deployment</TD><TD>9/29/2023</TD><TD>Wave 1</TD></TR><TR><TD>114400</TD><TD>Team 1</TD><TD>Deployment</TD><TD>10/2/2024</TD><TD>Wave 1</TD></TR><TR><TD>114400</TD><TD>Team 2</TD><TD>Deployment</TD><TD>12/2/2024</TD><TD>Wave 2</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>If there would be another tool i can use to do this open to suggestions</P> Mon, 09 Sep 2024 09:29:55 GMT https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Multirow-formula-to-identify-the-wave/m-p/1316242#M328327 Cherub7210 2024-09-09T09:29:55Z Re: Multirow formula to identify the wave https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Multirow-formula-to-identify-the-wave/m-p/1316249#M328329 <P><a href="https://community.alteryx.com/t5/user/viewprofilepage/user-id/456897">@Cherub7210</a>&nbsp;what is the expected output?</P> Mon, 09 Sep 2024 10:06:16 GMT https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Multirow-formula-to-identify-the-wave/m-p/1316249#M328329 binu_acs 2024-09-09T10:06:16Z Re: Multirow formula to identify the wave https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Multirow-formula-to-identify-the-wave/m-p/1316252#M328330 <P><a href="https://community.alteryx.com/t5/user/viewprofilepage/user-id/194502">@binu_acs</a>&nbsp;the expected out is in the expected output column</P><P>&nbsp;</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>Proj Id</TD><TD>Project Name</TD><TD>Task</TD><TD>Due on Date</TD><TD><STRONG>Expected Output</STRONG></TD></TR><TR><TD>106751</TD><TD>Action item 2</TD><TD>Deployment</TD><TD>10/31/2024</TD><TD>Wave 2</TD></TR><TR><TD>106751</TD><TD>Action item 1</TD><TD>Deployment</TD><TD>9/29/2023</TD><TD>Wave 1</TD></TR><TR><TD>114400</TD><TD>Team 1</TD><TD>Deployment</TD><TD>10/2/2024</TD><TD>Wave 1</TD></TR><TR><TD>114400</TD><TD>Team 2</TD><TD>Deployment</TD><TD>12/2/2024</TD><TD>Wave 2</TD></TR></TBODY></TABLE><P>&nbsp;</P> Mon, 09 Sep 2024 10:16:29 GMT https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Multirow-formula-to-identify-the-wave/m-p/1316252#M328330 Cherub7210 2024-09-09T10:16:29Z Re: Multirow formula to identify the wave https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Multirow-formula-to-identify-the-wave/m-p/1316257#M328331 <P><a href="https://community.alteryx.com/t5/user/viewprofilepage/user-id/456897">@Cherub7210</a>&nbsp;can you explain the logic?</P> Mon, 09 Sep 2024 10:28:41 GMT https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Multirow-formula-to-identify-the-wave/m-p/1316257#M328331 binu_acs 2024-09-09T10:28:41Z Re: Multirow formula to identify the wave https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Multirow-formula-to-identify-the-wave/m-p/1316264#M328334 <P><a href="https://community.alteryx.com/t5/user/viewprofilepage/user-id/194502">@binu_acs</a>&nbsp;using the due on date i would like to identify what wave would it be. So it can be Wave 1 to Wave N depending on how may project id that are listed. apologies i think my example is incorrect. Here is an updated example. Wave 1 would be the earliest date, 2 the would be the next date to N where N is the newest date.</P><P>&nbsp;</P><P>In the example, proj id&nbsp;106751 has 2 instances and due on date 9/29/23 is the earliest and is tagged as wave 1 and then 10/31/24 would be Wave 2&nbsp;</P><P>&nbsp;</P><TABLE><TBODY><TR><TD><SPAN>Proj&nbsp;&nbsp;</SPAN>Id</TD><TD>Project Name</TD><TD>Task</TD><TD>Due on Date</TD><TD><STRONG>Expected Output</STRONG></TD></TR><TR><TD>106751</TD><TD>Action item 1</TD><TD>Deployment</TD><TD>10/31/2024</TD><TD>Wave 2</TD></TR><TR><TD>106751</TD><TD>Action item 1</TD><TD>Deployment</TD><TD>9/29/2023</TD><TD>Wave 1</TD></TR><TR><TD>114400</TD><TD>Team 1</TD><TD>Deployment</TD><TD>10/2/2024</TD><TD>Wave 1</TD></TR><TR><TD>114400</TD><TD>Team 1</TD><TD>Deployment</TD><TD>12/2/2024</TD><TD>Wave 2</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>hope this gives a clearer picture&nbsp;</P> Mon, 09 Sep 2024 10:52:01 GMT https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Multirow-formula-to-identify-the-wave/m-p/1316264#M328334 Cherub7210 2024-09-09T10:52:01Z Re: Multirow formula to identify the wave https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Multirow-formula-to-identify-the-wave/m-p/1316271#M328338 <P><a href="https://community.alteryx.com/t5/user/viewprofilepage/user-id/456897">@Cherub7210</a>&nbsp;one way of doing this</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="image.png" style="width: 614px;"><img src="https://community.alteryx.com/t5/image/serverpage/image-id/373375iA8CCDC1F8D21BD2F/image-dimensions/614x339?v=v2" width="614" height="339" role="button" title="image.png" alt="image.png" /></span></P> Mon, 09 Sep 2024 11:19:42 GMT https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Multirow-formula-to-identify-the-wave/m-p/1316271#M328338 binu_acs 2024-09-09T11:19:42Z