Expand my Community achievements bar.

Join us on September 25th for a must-attend webinar featuring Adobe Experience Maker winner Anish Raul. Discover how leading enterprises are adopting AI into their workflows securely, responsibly, and at scale.
SOLVED

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

Avatar

Level 2

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.

1 Accepted Solution

Avatar

Correct answer by
Moderator

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

View solution in original post

2 Replies

Avatar

Correct answer by
Moderator

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

Avatar

Level 2

Thanks