I thought that passing the list of column names saved as a List data type as a variable to the Colum Filter node would work but it seems like all of the fields from the source data is still coming through. Anything I am missing here?
I tried using the Referenced Column Filter node and pass along the fields from the other source but it was not working.
anyone have a basic example of this they can share?
Hey there,
I think I came across this with Pivot node or something else - I also just tested it.
I’m afraid just passing in those that you want included is not enough. You also need to pass in those, that you want to exclude:
Set(x) => those are the columns I want to keep
Set(y) => those are the columns I want out…
With this set up it works… obviously cumbersome to implement… will see if I find the topic I created in the feedback section…
Ok-- thanks. not urgent but appreciate you looking into it. For now I can manage the filtering manually for this use case.
With regards to do this via variables - this is it for now ;-). I.e. you need to provide sets for both what you want to keep and what you want removed…
Will link the topic for hopefully collecting your vote on that topic to make it easier (and also consistent with I think how Group By works)
Yes passing in both Lists appears to have work as described. Appreciate the input.
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.
