Dataset lookup issues | Community
Skip to main content
KotiSyamala
KotiSyamala
Level 5
February 26, 2025
Solved

Dataset lookup issues

  • February 26, 2025
  • 3 replies
  • 810 views

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-not-working/m-p/725853

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

 

Best answer by KotiSyamala

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.

 

3 replies

I
Adobe Employee
IvanMi1Adobe Employee
Adobe Employee
February 26, 2025

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

    arpan-garg
    Community Advisor
    arpan-gargCommunity Advisor
    Community Advisor
    February 27, 2025

    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
      KotiSyamalaAuthor
      Level 5
      March 1, 2025

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

        Sukrity_Wadhwa
        Community Manager
        Sukrity_WadhwaCommunity Manager
        Community Manager
        April 2, 2025

        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!

        Sukrity Wadhwa
        KotiSyamala
        KotiSyamalaAuthorAccepted solution
        Level 5
        April 3, 2025

        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.

         

        Terms & ConditionsAccessibility statement

        Loading footer...