cancel
Showing results for 
Search instead for 
Did you mean: 

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

UrsVinny
New Contributor II

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

image

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

1 ACCEPTED SOLUTION

alchemiz
Contributor III

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

View solution in original post

2 REPLIES 2

alchemiz
Contributor III

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
New Contributor II

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