Discover the winners & finalists of the 2022 Dataiku Frontrunner Awards!READ THEIR USE CASES

Edit select list after post-filter in joins

0 Kudos

In many cases, some columns are selected or generated during joins just for filtering, but shouldn't be included in the output. A common example is A not B type joins, where I need to left-join, then filter where B.key is null. B.key should be excluded in the output dataset, but has to be included in the select list in order to perform the filter. By adjusting the workflow of the join recipe, these common types of joins can be set up without needing a prepare recipe afterward to reduce the select list. 

1 Comment
Status changed to: Acknowledged

Hi @natejgardner ,

Thanks for the feedback, we've received your request - it's actually something we're currently exploring. We'll keep you posted with potential updates here!