08-15-2023 11:28 PM - last edited on 08-23-2023 10:55 AM by dmiller
Hi Team,
I'm pulling data from the source system which have "n" columns, I wanted to count the number of columns that I'm getting from the Source System. So that to map them with the respective Target System.
Please help me out this, Thanks in advance.
Solved! Go to Solution.
08-17-2023 01:07 AM
Hi @Manzoor ,
You can use the following expression to replace the NULL values with blank in the entity object, assuming it is a flat object.
$entity.mapValues(val => val == null ? "" : val)
This will simply iterate over each value in the entity object, and check if the value is null, if it is, it will return an empty string otherwise it will return the original value.
08-17-2023 03:33 AM
Thank you @j_angelevski