Column Filter Automation Through Flow Variables

[Giacomo_Di_Ruvo]

Hi everyone!

I’m trying to automate a Column Filter node using flow variables, but I’m having a hard time figuring out how to do it.

Basically, what I am trying to do is creating a variable with the column name and injecting it into the Column Filter node (specifically in the Overwrite included_names field).

I’m definitely doing something wrong. Can anyone help me?

Thanks in advance!

[hmfa]

Hi @Giacomo_Di_Ruvo .

Try if this solution works for you.

Column Filter using Variable

Hi @karapapas, you can do that by first turning your column names into row IDs using the RowID node, then Transposing the table and finally using a Reference Column Filter to only keep the wanted columns from the other table. Please see attached workflow, which shows how it is done. Kind regards Alexander column filter.knwf (11.1 KB)

Best regards

[MartinDDDD]

if you don’t feel like transposing then this might be helpful. When passing in variables to determine inclusion column names you need to move the setting of “any unknown column” to the exclusion box, before you configure your flow variable…

table comparison

Ok this is somewhat a weird one. Column filter behavior when using flow variables is a bit awkward. I did some tests and managed to get it work for the first iteration when I passed the exclusion columns (manually generated them for first iteration) as flow variables in addition to the inclusion columns - this worked! I then copied the workflow and removed the inclusion columns keeping exclusion columns and this also worked! I then took a closer look at your configuration of column filter BE…

[Giacomo_Di_Ruvo]

I think I already solved this part. I’m currently stuck at che configuration of the Column Filter node.

I basically have no idea how to inject the variable inside the Column Filter node

[Giacomo_Di_Ruvo]

It seems to be working now! I checked the workflow you provided to copy the setup and it was exactly the same thing I was already doing, but for some reason it wasn’t working.

All solved now, thanks everyone!