Is there a way to do vertical pivoting in denodo?
I have one data element which is a combination of 3 fields basically seperated by ~.
So the first seperation till ~ belongs to field A, second part belongs to field B and third belongs to field 3.
I applied split('~',Data element) which splits but return in terms of array. Flattening this array creates duplicates. I need to either pivot the array vertically or need to understand how will i retrieve individual array elements.
Please help !