Edit select list after post-filter in joins

Options
natejgardner
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
0 votes

In the Backlog · Last Updated

Comments

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

    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!

    Best,

    Katie

Setup Info
    Tags
      Help me…