Designing and Running Pipelines

Resolved! How to map multiple target path to single field name

Hi all, I have a sample data as below: “TRANSCU2”: “T1” “TRANSCU3”: “T4” “TRANSCU4”: “T8” “TRANSCU6”: “T90H” “TRANSCU7”: “T67” “TRANSCU8”: “T653” But i wanted to map all source field to single target path like below: “CU”:“T1” “CU”:“T4” “CU”:“T8” “CU...

Resolved! To get sum of value present in between special character like '|'

Hello Community, I need to get the sum of value present in between special character ‘|’. Length of input may vary, one such scenario is attached. Please suggest. Output getting after aggregate : “NEUTSUM”: “261.02||697.13|359.22” I need to get sum ...

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

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

Setting content-length in REST PUT snap for SharePoint API

Hi gang, Hoping this awesome community can help me figure this out. Our team is trying to reconstruct some pipelines for uploading documents to SharePoint. Where we’re running in to a snag is after we’ve already received an OAuth 2 token and created ...

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

Can Excel Formatter Insert Data at an Offset (Column or Row)?

I have a requirement, that I insert data into a series of sheets in an Excel workbook - and the sheets are not blank. Is there a way to tell the Excel formatters (would love to use the multi-sheet formatter for this) to start inserting at a particula...

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

SnapLogic - Integration Nation

Forum Posts

Resolved! How to map multiple target path to single field name

Resolved! To get sum of value present in between special character like '|'

Ternary operation to handle diff date formats

Resolved! Date Issue in Pipeline Parameter

Setting content-length in REST PUT snap for SharePoint API

Resolved! Vlookup betwen two tables

Can Excel Formatter Insert Data at an Offset (Column or Row)?

Resolved! Using sl.zipObject with Headerless CSV

Transpose columns(Dynamic) into rows.

Is migrating of REST Snap to Http Client still man...

Change all Keys in JSON structure to lowercase

How to read .xlsb file

Append input data vertically

Difference between 2 dates

Find unmatched data using join

split target csv file into more smaller CSV's

How can I edit/update my community posts?

Http Client Snap vs REST Post snap