Hello, wondering if anyone has a solution for the below, i have a table that im trying to run the table tool it has a couple columns and some columns contains the same "TEXT" inside the column header.
ideally what i would like to do is IF column header Contains 'NUM' then change text to 'Red'
something like that
so if the below is the main table
| John_Smith | Num_1 | Roger_Allen | Num_2 | John_M_Rogers | Num_3 | West_Coast_Bank | Num_4 |
Then the desired output would be the below
| John_Smith | Num_1 | Roger_Allen | Num_2 | John_M_Rogers | Num_3 | West_Coast_Bank | Num_4 |
i tried using the Dynamic Files Create Column rule but when i do the following - Contains([_CurrentFieldName_], 'Num_') and change the text to red it changes the rows value to red in the Num_ column not the actual header
does anyone have a solution for this?
also just a note ... the Num_ columns will never be the same 1 run there might be 5 Num_ columns one time there might be 2 Num_ columns so i cant create a run on those specific columns as they are always changing.
thank you
