02-10-2023 02:32 AM
How to change the Target path based on the Mapper Expression.
On the source file the Column name can be either Overall Manpower(FTE) or Overall Resources(FTE).
In the mapper table expression builder I am using the below Expression.
$input0.findIndex(x=>x.O == “Overall Manpower (FTE)”) || $input0.findIndex(x=>x.O == “Overall Resources (FTE)”)
On the Target Path can i use two different targets e.g., $ConstructionOverallManpowerFTERow || $ConstructionOverallResourcesFTERow
I even tried conditional snap but got an error.
Please suggest the possible solution.
Cheers
Vinny
02-10-2023 03:45 AM
Hi @UrsVinny,
You can try using Mapper with Null-Safe access on,
And after this Mapper use another one that will filter null value from the root object.
Example Input:
Example Output:
Let me know if this helps you.
BR,
Aleksandar.
02-10-2023 08:23 AM
Thanks Aleksandar!
Will try and let you know.
Thanks once again.