Forum Discussion

UrsVinny's avatar
UrsVinny
New Contributor II
3 years ago
Solved

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