Hi All,
Please let me know if there is an alternative way to achieve my below requirement. I am currently using Summarize/Join tool for my requirement (Workflow attached).
I think this can be done in better way maybe using just 1 tool. Please let me know Thanks
Input data:
Output Expected:
Solved! Go to Solution.
Hey @ramkumarmaruthai,
One way to do this is using the Multi Row Formula Tool:
If you want to learn more about the Multi-Row-Formula Tool the community has some quick and easy videos on the topic here: https://community.alteryx.com/t5/Interactive-Lessons/Multi-Row-Formula/ta-p/82872
Any questions or issues please ask
Ira Watt
Technical Consultant
Watt@Bulien.com
Maybe you can use the Multi-Row Formula tool to get it .
1- Group by ID
2- Formula :
iif(isempty([Date]),[Row-1:Date],[Date])
Thanks a lot both 😊
No worries @ramkumarmaruthai! have a good one 😄