Hi @sharmilap,The reset sandbox feature removes all the custom created resources from the sandbox (includes schemas, datasets, profiles and so on).Check if the dataset you are referring to are System Datasets by applying the filter. Steps provided in the link mentioned below:https://experienceleague...
Hi @BellaSnow5378 , You can achieve this by using an Inline Function, sample query is mentioned below:SELECT inline(array(struct(1, 'a'), struct(2, 'b'))), 'AAA';https://experienceleague.adobe.com/en/docs/experience-platform/query/sql/syntax#inlineFor more details on higher-order functions follow th...
Hi @jm_11 , To be available to add to a CJA Connection, the dataset in AEP must have a regular schema, not an ad-hoc schema. Query-derived datasets have an ad-hoc schema, and this will prevent the dataset from being available to CJA.Hope this clarifies! Regards,Kumar Saurabh
Hi @xliu ,There are 2 points to consider in this solution:-1) The source data should not be already formatted as an array. You will have to modify your source to pass the Status field value as a string, and then use data prep function to Append Array.2) The _id column value must be unique for differ...
Hi @xliu ,The Experience Event Class _id field uniquely identifies individual events ingested into the platform. This field is used to track the uniqueness of an individual event in UPS, preventing duplication of events. Note:1) Duplicate events in Profile Service are dropped if the event with the s...
Hi @Sushmita32 ,Calculated attribute is used to add transformation logic.What I earlier meant was- If you have to map the attributes directly to xdm, you can directly do it in the Data Element, rather mapping them again in Datastream. https://experienceleague.adobe.com/en/docs/platform-learn/impleme...
Hi @Sushmita32 , for the attributes that has one-to-one mapping from the source Edge data, the Mapping is already created in Tag Properties (Under Data Element section), you don't have to Map them again (exception is _id and timestamp field).If you have to add logic using DataPrep functions only the...
Hi @Sushmita32 , For the first time you will have to manually add Calculated Field and add the logic to the console.If you have previously created a datastream, you can reuse its configured mapping rules for a new datastream by using the feature- Import Mapping. https://experienceleague.adobe.com/en...