Route the Pipeline based on the location (Cell range) of a Column in the Source excel file

[UrsVinny]

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

[alchemiz · Accepted solution]

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

[UrsVinny]

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