Dataset lookup issues

[KotiSyamala]

I’m encountering several issues with the dataset lookup:

1. Updated records not displaying: When records in the lookup dataset are updated, the changes are not reflected. For example, if record 101 has its name field updated, the new name value does not appear.

2. No results returned: For another dataset, no results are returned even though there is a matching record in the lookup dataset.

Gone through the thread https://experienceleaguecommunities.adobe.com/t5/journey-optimizer-questions/dataset-lookup-in-ajo-n...

but not able to conclude what's the cause and how it or this is an issue with lookup function.

@arpan-garg @Ivan_Mironchuk 

[Ivan_Mironchuk]

@KotiSyamala - can you please file a ticket with support so that we can get further details and investigate?

[arpan-garg]

Hi @KotiSyamala  - How are you accessing the data from the look up dataset? Can you please send an example here. Please make sure you don't enable the dataset for lookup multiple times, as per my understanding enabling a dataset for lookup after inserting the data in dataset results in random results. 

The order should be

1. Enable the dataset for lookup

2. Insert the data in dataset(Not realtime, you have to wait for watch processing to be complete).

3.Access the data.

Thanks,

Arpan

[KotiSyamala]

Did the same, but still facing the above-mentioned two issues. Raised Adobe support request.

[Sukrity_Wadhwa]

Hi @KotiSyamala,

It would be greatly appreciated if you could share the solution you received from Adobe Support with the community, so others facing similar issues can benefit from it.

Thanks!

[KotiSyamala · Accepted solution]

It's the dataset data ingestion issue,

Lookups don't return data if there are duplicate records with same id, we need to update the existing record in the dataset, instead of creating a new row in the table the resulting in empty response due to multiple rows returned with same id.