Edit select list after post-filter in joins

natejgardner Neuron, Registered, Neuron 2022, Neuron 2023 Posts: 151 Neuron

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.

0 votes

In the Backlog · Last Updated


  • Katie
    Katie Dataiker, Registered, Product Ideas Manager Posts: 105 Dataiker

    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!



Setup Info
      Help me…