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

Question

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:

Update missing records.yxmd

IraWatt · Accepted Answer

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 Answer

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