How can I calculate the number of a column whose ID matches a string?

I have a table with hundreds of columns. I am interested in knowing which column (when they are numbered 1 … X) has an ID that matches a given string. How can I figure that out? I was trying to accomplish this with Transpose -> GroupBy , but I can’t seem to figure out how to get GroupBy to tell me (what is then) the row number where a string occurs.

Use RowID node to add row number column before group by and include added column as groping or aggregation with min/max aggregation, depends on your goal.

1 Like