Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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
14 - Magnetar

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