User Activity

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