I have table where one column is type (array<string>)
elements of array varies in that column from 1 to 5 and more.
I want to explode all elements of array dynamically so that i can get one row.
I need help to see how i can achieve.
Any help is greatly appreciated.
Thank you in advance.
I am sorry, but I do not understand the requirement.
However, perhaps you are looking for the 'explode' UDF: