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

Designing Pipelines
1

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

image
image843×107 9.79 KB

image
image852×198 24.4 KB

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.

image
image951×222 41.4 KB

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

2

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
3

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