Thank you for looking at this post, first and foremost, as I am a very recent beginner and am sure this is a relatively obvious issue that I am unable to figure out.
I can get the output I need (workflow below) but have to make manual edits to the Column names from the Excel Reader node. However, I would like to be able to use either Wildcards or RegEx.
I am trying to aggregate columns that are either Debits or Credits using Column Aggregator with a Regular expression and cannot get it to filter!! I changed the type from D to S to I with no luck. I have tried grouping, extracting the column headers but then I get tripped up trying to replace, etc. Below are screenshots of the inputs and my workflow. Any help is appreciated!!!
It turns out that my original data headers had a hidden/special character and a line break (I copied the header cell from Excel to Notepad). The file is being saved from a virtual environment so, based on my Googling, Excel is formatting the data but not visibly.
What I did was use Column Rename (Regex) to clear the line breaks and characters:
And then I was able to use the Filter node in the expected way.
Thanks for showing it worked on your end and I needed to look at the source a little closer.
