Join data and Minifs formula on Alteryx

[JBATAIDE]

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

[RolandSchubert]

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