Update Missing records based on ID column - Without using Summary/Join tool

[ramkumarmaruthai]

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:

[IraWatt · Accepted 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 

[flying008 · Accepted solution]

Hi,@ramkumarmaruthai 

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])

[ramkumarmaruthai]

Thanks a lot both 😊

[IraWatt]

No worries @ramkumarmaruthai! have a good one 😄