Dynamic column filter

[fostc80857]

Hi

I would like to remove the last column of my dataset using a column filter node, however as the number of columns in the dataset will vary from month to month, is it possible to do this dynnamically?

Thanks
Chris

[iCFO]

You could list the column names (Column Header to Row then Transform), filter it down to the last one using the Group By node, then use that as a flow variable to select the column for filtering in the column filter or column filter Regex node.

[fostc80857]

Hi @iCFO

How would I filter down to the last one using the groupby node?

[iCFO]

I believe that there is a “Last” aggregation option.