This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
FAQ
UrsVinny
New Contributor II
since ‎10-14-2022
‎07-25-2023

User Statistics

  • 10 Posts
  • 0 Solutions
  • 1 Kudos given
  • 1 Kudos received

User Activity

Target path based on Mapper expression condition

02-10-2023
How to change the Target path based on the Mapper Expression. On the source file the Column name can be either Overall Manpower(FTE) or Overall Resources(FTE). In the mapper table expression builder I am using the below Expression. $input0.findIndex(...

Router Snap to check three diff versions of Excel template

02-08-2023
Hi As a source file i receive three diff versions of Excel Template. Version N Version N-1 Version Old The Source excel file contains a cover sheet and there on cover sheet on Cell B1 the excel template version is specified. I am using a variable $Ex...

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

01-12-2023
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 ...

JSON Generator with 'Or' operator

11-27-2022
Hi All I am reading an excel file which is having multiple worksheets in it. I need to check whether the worksheet name is matching with the Sheet name specified in JSON generator snap or not. Customer has recently came back and said that one of the ...

Ternary operation to handle diff date formats

10-19-2022
The source file contains Reporting Period value in diff date format. Aug-2022 Aug-22 AUG 2022 August-2022 I am using the below ternary expression to handle the above mentioned date pattern. isNaN(Date.parse($RPT_MONTH,‘MMM-yyyy’)) || isNaN(Date.parse...
Kudos from
Kudos given to
View all