UrsVinny
New Contributor II
Joined 3 years ago
User Profile
User Widgets
Contributions
Target path based on Mapper expression condition
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(x=>x.O == “Overall Manpower (FTE)”) || $input0.findIndex(x=>x.O == “Overall Resources (FTE)”) On the Target Path can i use two different targets e.g., $ConstructionOverallManpowerFTERow || $ConstructionOverallResourcesFTERow I even tried conditional snap but got an error. Please suggest the possible solution. Cheers Vinny2.4KViews0likes2CommentsRouter Snap to check three diff versions of Excel template
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 $Excel_Template_Version in the mapper to retrieve the value as shown in the below screen shot. Later on based on the version of the template the Pipeline takes different path and for that I am using a Router snap to check the version. But while processing the Version N i am getting an error,below is the screen shot of the Router Snap settings. The error message is furnished below. “error”: “Router expression $Excel_TEMPLATE_VERSION did not evaluate to a boolean value. Instead got type: String” I believe I m getting this error message because the router snap documents to different output views based on a boolean expression and there in my router snap i have checked the Firstmatch checkbox and if the Template is not N-1 or Old then it throws that above error message. Again, Router expect 1 input and minimum 2 output. Can i add something like this as output: Version 22.1 || Version 23.1 for Input0. Do let me know the possible solution to meet this requirement? Thanks Vinny1.5KViews0likes1CommentRoute 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 CashInvoicePaymentTerm table is available on Cell 117-B as shown in the below screen shot. In our Current Pipeline we have a mapper snap which checks the Item Name on the cell 88-B 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. 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 VinnySolved2.3KViews0likes2CommentsJSON Generator with 'Or' operator
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 worksheet name can be with ‘|’ suffixed and Prefixed with its name and again in some of the source file the worksheet name will be without ‘|’. |Dashboard| Dashboard As of now in the JSON editor snap I am using the below code. Is it possible to include ‘OR’ in the same JSON code? And if not then how can we process if the worksheet name is with and without ‘|’ operator. Cheers Vinny3.2KViews0likes2CommentsTernary operation to handle diff date formats
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($RPT_MONTH,‘MMM-yy’)) ? $RPT_MONTH : Date.parse($RPT_MONTH,‘MMM-yy’).toLocaleDateString({“format”:“MMM yyyy”}) But when the value is in August-2022 the above code is not converting it into AUG 2022 Any kind of help will be highly appreciated. Cheers Vinny5.3KViews0likes9Comments