Hi @BitunSenAEP It may be easiest to use Data Distiller and SQL to build this type of audience in AEP. I have provided some documentation down below:Build Audiences using SQL | Adobe Experience Platform

Hi @ShivaniM  If you are needing a field to populate within the segmentation editor, you either have to have ingested data for that particular field, or selected to show all fields (not only fields with xdm data). If a schema is disabled for profile, data will not be included in the profile store.

Hello @SonikaDU  Let me know if this documentation answers your questionsBest Practices For Data Modeling | Adobe Experience Platform

Hi @shubham10  If I'm understanding correctly, you have created an Individual Profile Schema along with a Lookup Schema in AEP, and you want to establish a relationship? Have you followed this documentation by chance?Define a Relationship Between Two Schemas Using the Schema Editor | Adobe Experienc...

Hi @Indra  My understanding of the 2 datasets is as follows: Profile Export for Destination Merge Policy would be useful for the data export based on specific merge policies. I.e. Timestamp vs Dataset Precedence Profile Snapshot is useful for any type of historical analysis you may need, or auditing...

Hi @dparraa  The data that you are using within your attributes of the segment, are only allowed for Batch Evaluation. For example, using multi-entity segmentation only allows for Batch Evaluation, as seen here Multi-entity Segmentation Overview | Adobe Experience Platform.   You should also read th...

Hi @user48  I pulled this basic definition from MS documentation: "Delta Format is an open-source storage layer that brings reliability to data lakes"   I would recommend reaching out to Adobe Support through a ticket, to gather more information direct to your organization for further details on the...

To tag onto @Harveer_SinghGi1 's answer--The doc states: To improve efficiency and make dataset operations less expensive, organizations who have been moved to the Delta format can delete data from the Identity Service, Real-Time Customer Profile, and the data lake. This type of user is referred to ...

@MeenalBo2 can't seem to find any info about how on-demand evaluations are affected. @brekrut thinking you may have more experience with this one, if you could help out?

Hi @RitwikMo  You'd have to explode the array. Try below:SELECT * FROM pe_cust_ren_sub WHERE EXISTS ( SELECT 1 FROM explode (BillInvoiceDate) AS date WHERE date = CURRENT_DATE - INTERVAL '1 day'