hi team, as titled, how to rename 'row1' to 'number' after transpose. I tried rename and replace, but doesn't work.
<your_base> | transpose | rename "row 1" as number
Use double quotes around "row 1".