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

Again, in another version the CashInvoicePaymentTerm table is available on Cell 117-B as shown in the below screen shot.

image
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

1 Like

U r a Rock Star… !!
Thanks for your support. I added the expression as suggested by you with some minor changes and it worked.

Cheers
Vinny