SQL Query for transforming array based objects in dataset in adobe experience platform

[RitwikMo]

I have a dataset which has array based object called _seit.It has three sub fields:

standardint integer,

favchoice string,

se_id string

How to flatten it using sql query as part of query services.

[arijitg · Accepted solution]

Hi @RitwikMo 

This has been answered in below topic. Please take a look.

Solved: Need to use Multiple explode function - Adobe Experience League Community - 668192

Regards,

Arijit Ghosh

[RitwikMo]

Thanks