Hi @Michael_Soprano,You can perform an outer join between the event dataset (current array) and resulting profile dataset (existing array) based on common id and then perform an array_join (considering both event and profile elements are array): resource P.S.1. I have never done it, so you need to d...

Hi @ShivaniM ,I have not used this dataset, however, looking at the result set, it seems this dataset holds on to all different versions of the audience. For e.g. - if there are 5 rows with same id (in IdentityMap field), then I assume this segment has been modified 4 times.1. is it possible that de...

Hi @Michael_Soprano ,considering all the field types (target & source) are correct, please try with below way. Using "STRUCT" keyword you have to create the json like structure (unlike to sql where you use fields to be insert in insert clause): Learn More  Sample:INSERT INTO from_event_to_profile_da...

Can you share the error! Also in terms of debugging, I can see "segment_ingestion_dataset" is at the inner most query, so is that one failing?To add further, I do not see "origin" field in this dataset, I guess you have to share most of the query for debugging.

Hey @AnkitJasani29 ,If you simulate this criteria as a segement (in UI segment builder) and then change view to PQL, I think you will get the interpretation. Hope this resolves!

Hi @GabrielaNa1 , Helpful video hereYou can drag and drop the field like this:You can choose how to compare: whether to form a group with the 1st attribute or use in comparison. Once I have chosen for comparison, it will look something like below: Hope this resolves!

Hi @dhickman13 I was thoroughly confused as well and looked at my own environment and played around it before answering you Boat_Activity_Date "In Last" 5 Years" typically translates to: Boat_Activity_Date falls within "Last 5 years" from today, i.e. falls within 07/05/2020 (DD-MM-YYYY). So the con...

Hi @DanSpigs1,Are you trying to delete or add a few fields from that field group (mixin)? If delete yes: then my assumption of the error: I think those fields are already part of some schema (and hence the dataset) and they were enabled for profile. So, now although you were able to delete the datas...

I have not worked with AA connector, but I think the event dataset by default as both "timestamp" and "_id" as required fields (please check at your end in your schema). So, these 2 fields you have to fill in the the request body.You can do a quick test where:Key in a proper datetime field into "tim...

You can look into catalog API where you will get the full view: urlUse an extra query param:Key = propertiesValue = observableSchema