Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

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

ramkumarmaruthai
5 - Atom

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:

ramkumarmaruthai_0-1661244488822.png

 

Output Expected:

 

ramkumarmaruthai_2-1661244764530.png

 

 

4 REPLIES 4
IraWatt
17 - Castor
17 - Castor

Hey @ramkumarmaruthai,

One way to do this is using the Multi Row Formula Tool:

IraWatt_0-1661245406856.png

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
15 - Aurora

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

 

录制_2022_08_23_17_07_27_682.gif

ramkumarmaruthai
5 - Atom

Thanks a lot both 😊

IraWatt
17 - Castor
17 - Castor

No worries @ramkumarmaruthai! have a good one 😄

Labels
Top Solution Authors