Data prep mapping for missing SKU not working as expected.

[BReyes17]

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!

[supratim320]

Hi @BReyes17 ,

"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]

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

[BReyes17 · Accepted solution]

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-...