Hi Gary
I would say write an UDF
Thanks and Regards
Rajesh
On Sun, Sep 29, 2013 at 5:16 AM, Gary Zhao wrote:
> Hello
>
> Do you know if my scenario is supported or not, or how I may do it.
> Basically, I have an array in a recode, like
>
> [1, 2, 3]
>
> What I want is to explode it twice so I
Hello
Do you know if my scenario is supported or not, or how I may do it.
Basically, I have an array in a recode, like
[1, 2, 3]
What I want is to explode it twice so I can have the following output:
1 2
1 3
2 1
2 3
3 1
3 2
I tried a few queries but couldn't make it succeed.
Thanks
Gary
