Nível 1
Nível 2
Faça login na Comunidade
Faça logon para exibir todas as medalhas
Hi,
I am writing into an array inside a data set using query service daily against a profile , coming next run we wish previous values of array to get replaced with the new values. As we notice right now values inside array fields are getting appended rather getting replaced.
Example -
Day 1 :
Data ingested using query (batch)
ID |
Product Viewed Recently (array) |
123 |
‘A','B','C' |
In Profile we see Product Viewed Recently as ‘A’,’B’,’C’ across 0,1,2, array placement
Day 2
Data ingested using query (batch)
ID |
Product Viewed Recently (array) |
123 |
‘D’,’E’,’F’ |
In Profile we see Product Viewed Recently as ‘A’,’B’,’C’ ,’D’,’E’,’F’ across 0,1,2, 3,4,5 array placement. Whereas only want to see ‘D’,’E’,’F’.
Is there a way for specific dataset we can set possibility of replacing an array field instead of appending ?
Solucionado! Ir para a Solução.
Visualizações
respostas
Total de curtidas
Hi Nikhil,
Little curious on how "Product Viewed Recently (array)" is used in a profile class and not in event.
Can you try the mapper function upsert_array_replace and see if it does the overwrite for you? (If your dataset is upsert enabled)
Ref : Data Prep Mapping Functions | Adobe Experience Platform
Visualizações
respostas
Total de curtidas
Can you tell us a little more about:
By default the array should be replaced, assuming:
Visualizações
respostas
Total de curtidas
Hi Danny-Miller,
Here are my comments , thanks in advance
Can you tell us a little more about:
By default the array should be replaced, assuming:
Visualizações
respostas
Total de curtidas
Interesting. It might help to see the actual code/data, but sounds like you are doing the right thing.
Visualizações
respostas
Total de curtidas
I tried inserting array values for the same profile via data flow (batch) as well skipping the query service to test if previous array is replaced or appended. In this case also I see new array values getting added to array list rather than replacing the previous one. Could this be any property setting of dataset / schema
Visualizações
respostas
Total de curtidas
Not that I know of. I'd try and reproduce it in a new sandbox, schema, dataset, etc. and simplify it down as much as possible. Then open a ticket &/or come back here with actual screenshots and queries.
Visualizações
respostas
Total de curtidas
Hi Nikhil,
Little curious on how "Product Viewed Recently (array)" is used in a profile class and not in event.
Can you try the mapper function upsert_array_replace and see if it does the overwrite for you? (If your dataset is upsert enabled)
Ref : Data Prep Mapping Functions | Adobe Experience Platform
Visualizações
respostas
Total de curtidas
Yes dataset is upsert enabled, this makes sense. I think when dataset is upsert enabled Array enrichment is considered as append rather than replacing current array (which I think could make sense ). Possible solution could be to either disable upsert true
Visualizações
respostas
Total de curtidas
Visualizações
Curtida
respostas
Visualizações
Curtida
respostas