Designing and Running Pipelines
Discuss how to use the SnapLogic platform.
cancel
Showing results for 
Search instead for 
Did you mean: 

Forum Posts

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

UrsVinny by New Contributor II
  • 1486 Views
  • 9 replies
  • 5 kudos

Resolved! Date Issue in Pipeline Parameter

Hi All, I have a requirement to pass date in YYYY-MM-DD format and I am using the expression “Date.now().toLocaleDateString()” but I have the below issue. When I use it in pipeline parameter “Effective_Date” then use _Effective_Date in the pipeline ...

Resolved! Vlookup betwen two tables

Hi snaplogic experts, lets say i have excel(A) with 10 values in one column (branches) on left side and on the right side i have excel(B) with two columns (branches and managers). iam able to read them separately … but how can i create something like...

SL12345 by New Contributor III
  • 696 Views
  • 4 replies
  • 2 kudos

Resolved! Using sl.zipObject with Headerless CSV

Hoping someone might be able to find a solution to a challenge I have. I have a headerless csv file. I’m also reading in a header array that I wish to match up with the data in the headerless csv. I don’t want to add the header values to the CSV Pars...

Resolved! Map Values into an Array

I have a document that contains several records with key/value pairs. [ {“DOB_Date”: “1960-07-04”, “First_Name”: “Bobby”, “ID”: “99999”, “Last_Name”: “Fischer”}, {“DOB_Date”: “1970-08-24”, “First_Name”: “Wade”, “ID”: “99988”, “Last_Name”: “Boggs”}. ...

Snap aborted error

Hi , I am tryin to execute a pipeline which was already working fine. but all of suddent i see below error appeared and i am unable to get the thing resolved. Please let me know if any one has any idea on this. I am using filepollar for each fiel rea...

Varun by New Contributor
  • 1331 Views
  • 1 replies
  • 0 kudos