Ready for Dataiku 10? Try out the Crash Course on new features!GET STARTED

Join Visual Recipe - Advanced Join

Level 1
Join Visual Recipe - Advanced Join

Hi All-

Does any of you have an example of how advanced join works? where in the options are as below

First Data Set : Keep All

Second Data Set: Keep a subset of matching rows

Keep "1" match with "the largest value"  of field "Column1"

Column 1 --> has alphanumeric values ex: "777|2345692|RoleName|4454557777|ABC"

Trying to understand, how will the "the largest value"  of field "Column1" would work since the column has value which is alphanumeric.

Any reference to any article talking about advanced join is also greatly appreciated.


0 Kudos
1 Reply
Level 4

Hi @RanjithJose ,

Keeping a subset of matching rows seems similar to Match and then Filter. In the visual Join recipe, on the left side of the screen, is a "Post-Filter" option. With that you can specify filtering of the matched results. 

Hope this helps! Cheers, 


EDIT : as my work dictates transparency and understandability(is that a word?)  for non-tech users i generally try to keep the joins as simple as possible. Any pre- or postprocessing is separated in pre- or aftersteps in a different recipe, mostly prepare-recipes. To keep the flow understandable smart usage of zones help a lot.  

0 Kudos
A banner prompting to get Dataiku DSS