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 CashInvo...
  • alchemiz's avatar
    alchemiz
    3 years ago

    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

alchemiz's avatar
alchemiz
Contributor III
3 years ago

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's avatar
    UrsVinny
    New Contributor II
    3 years ago

    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