Generalise Work Flow

[Tushar_07]

I have Multiple spreadsheets. These spreadsheets are in same format and I need same results from every spreadsheet. But the problem with this spreadsheets is, there is one column name which changes per every spreadsheet and I am using nodes like column rename, string to number which can’t identify this change and my workflow fails.

Example:



If I have tables like this, and if I want that every time my workflow identify “Amount” column as a same column and perform a node like string to number, what should I do?

[quaeler]

You’ll want to use the " Column Rename (Regex)" node after your spreadsheet reader node and before your subsequent processing nodes.

Column Rename (Regex) — NodePit

[Tushar_07]

Hi @quaeler
I am fairly new to the Regex. In my case if I want to rename all “Amount*” columns as a “Amount” what will be the expression?

[quaeler]