Route the Pipeline based on the location (Cell range) of a Column in the Source excel file
We have two different version of Source file in one version the CashInvoicePaymentTerm table is available on Cell 88-B as shown in the below screen shot.
Again, in another version the CashInvoicePaymentTerm table is available on Cell 117-B as shown in the below screen shot.
In our Current Pipeline we have a mapper snap which checks the Item Name on the cell 88-B
I am thinking of adding a router between Head and Mapper Snap and based on the condition it will take that particular route.
Some what like this.
But I am struggling to put the conditional expression in router snap based on which the path will get decided.
Do let me know if you have any questions?
Cheers
Vinny
Hi Vinny,
Good day, you can also use the || operator and enable null-safe access property of the mapper snap
Expression:
$input0[‘117-1’][‘B’] || $input0[‘88-1’][‘B’]
If 117-B value is null or an empty string then get value in 88-B
Thanks,
MM
