String Manipulation - address column via variable


I tried to use the StringManipulation node within a loop.

I have several columns (changing) to address. Therefore I would like to address the column with a variable, but could not figure out how.

Given my variable is called VARIABLENAME, I search something like


I tried as well to create a temporary table with the rule engine, but also here I could not get the value of a column by using the VARIABLENAME to address the right column.


Try the extract column header node to reference the column more consistently.  You can then Create a new column with the original name and filter out the renamed column.  Attached is an example.

Thank you Aaron, that helped!