Data prep mapping for missing SKU not working as expected. | Community
Skip to main content
B
BryantRe
Level 2
July 20, 2025
Solved

Data prep mapping for missing SKU not working as expected.

  • July 20, 2025
  • 2 replies
  • 344 views

Hi all,

I've run into issues with mapping inside the data prep tool, specifically within productListItems. The solution would need to be able to iterate through an array.

Currently running into an issue where productListItems.SKU is missing. My team has been unable to reproduce the issue but have decided that temporarily putting in a fake SKU while resolving the issue would allow datasets to continue to be ingested while giving us the ability to search for the errors.

In Data Prep, we have used the following calculated field but to not success.

  • iif(is_empty(productListItems.SKU) == true, "MISS_SKU", productListItems.SKU)
  • iif(is_empty(SKU) == true, "MISS_SKU", SKU)

The target field is productListItems[*].SKU.

Any help would be appreciated!

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by BryantRe

Hey @blasta86794993 ,

 

I did get an answer in a similar thread. It seems that we cannot manipulate arrays in the data mapping tools using calculated fields so the best option would be to change the data at the source or in data collection. 

 

https://experienceleaguecommunities.adobe.com/t5/adobe-experience-platform/mapping-within-data-prep-tool-for-productlistitems-quantity-not/td-p/765189

2 replies

S
supratim320
Level 5
July 25, 2025

Hi @bryantre ,

"productListItems" is an array object and handling null check to be checked in that fashion. I have not tried such data manipulation, however, if I may suggest to handle it in the source system itself. I know query service can handle your requirement, but not sure on the data prep side!

blasta86794993
blasta86794993
Level 2
August 2, 2025

Did you ever get a response to this? I'm struggling with the same thing.

B
BryantReAuthorAccepted solution
Level 2
August 6, 2025

Hey @blasta86794993 ,

 

I did get an answer in a similar thread. It seems that we cannot manipulate arrays in the data mapping tools using calculated fields so the best option would be to change the data at the source or in data collection. 

 

https://experienceleaguecommunities.adobe.com/t5/adobe-experience-platform/mapping-within-data-prep-tool-for-productlistitems-quantity-not/td-p/765189

Terms & ConditionsAccessibility statement

Loading footer...