Pivot from columns to rows?
I have a table that looks like that:
|ID||completion_Rate - step1||completion_Rate - step2||completion_Rate - step3|
I want to Pivot it to that:
I know we don't have Pivot function in Vertica, but maybe there is a smart way to do it?
(If not, I'll take it a step back, the original table looks like that:
So if there is another way to "explode" this string into rows, that doesn't use split part to convert to columns first it will also help me.
I tried splitting into columns, but now I don't find a way to pivot