I have a workflow where I’ve pivoted a column to rows and aggregated a VIN count in each of the new resulting columns. However, I’d like to insert the name of the column into each specific cell if the value of that current cell is greater than 1. If it’s missing or not greater than 1 then do nothing.
I think I understand what you want to do but can you either upload or paste an example of your incoming table structure? I could give it a try.
If you are familiar what I’m thinking is you pass each column using column loop. Then regex rename the column to a generic name like “column”. Then use a rule engine to do your if column >=1 then pass the original column name into that cell if not then null.
Then you use regex rename to convert back to original column name.