@mansibedi Check the explode option supported via AEP, first explode the array into multiple rows and then do your business logic on derived column. I have used this many times, let me know if you need more details. Spark Function support by AEP.https://experienceleague.adobe.com/docs/experience-pl...