This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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.
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.