Agree with @nnakirikanti  on this approach.  Creating a rank of an attribute can be performed using data distiller or using audience compositions.

You can define an array within the XDM Individual profile class.   You would include the array in the audience criteria and include the a count function which is equal to 1 to account for 1 item of the array. You would then define the attributes of tp_code = foo and tp_event = 12345

Are you using Assurance and or console logging.  You can debug by passing in the query string parameter ?alloy_debug=true.  The results will be logged into the browser console.

Adobe Workfront is a operational MarTech component which can be integrated with RTCDP. You can using Adobe Workfront Fusion to expose data in regards to audiences, offers, datasets, schemas from Adobe RTCDP into Workfront. 

@Prateek-Garg  Glad you were able to solve the issue.  When using the source type of attribute the source of the data did not transform to the new format.  Using Expression can apply an expression upon the source to meet the target.

Hi @NickMannion , The destination will consist of a detainationId and a display name of the destination. I would check out the following to alter the display name.https://developer.adobe.com/experience-platform-apis/references/destinations/#operation/patchConnectionById

When inserting dates into Adobe Experience Platform the data format for dateTime should be ISO 8601 format.  https://experienceleague.adobe.com/en/docs/experience-platform/data-prep/functions#date-and-time  

Hello @moni268  Ideally if you looking to perform limit the number of profiles which qualify for an audience, I recommend looking into the condition activity of Adobe Journey Optimizer.The profile cap allows you to allow you to provide a limit on the number of profiles for a branch. https://experien...

Hello @4uSwan  The union schema view provided in your initial post to the thread appears to be a customer schema.  If the last data was ingested in Oct I not believe you will be able to see a preview of the data. Can you please help clarify as to what the field beenMembshipID has been mapped to a wh...

@_Saurabh_  Are you attempting to filter down your results to a specific segment a profile qualifies for?