community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
#SANTALYTICS

The highly anticipated Alteryx Community tradition is back! We hope you'll join us!

Learn More
We will be upgrading the Gallery to our 2019.4 release this Saturday, December 7th beginning at 9:00am MT. We expect the outage to take last approx. 2.5 hours.

Join data and Minifs formula on Alteryx

Meteoroid

Hi,


I need to join data from two datasets. A new column would be created on one of the sources which would retrieve the minimum value from the other source where there is a match for three columns in this example.

In excel I would use Minifs, but I am not sure whether it is possible with Alteryx or if I would have to do it in two or more steps using the formula and join tools.

 

Please find the example in attachment.

 

Thank you in advance,

Joao

Alteryx Certified Partner
Alteryx Certified Partner

Hi @JBATAIDE ,

 

the approach should be a Join tool to find combinations of datasource 1 and datasource 2, a Union tool to also consider combinations not existing in datasource 2 and a Summarize tool to identify the minimum values. I've attached a sample workflow. Hope this is helpful.

 

Best

 

Roland

 

 

Labels