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

Forum Posts

Writing flat file

Hi Team For my current use case, I need to write a flat-file. I am using the following pipeline to write csv. Input to JSON formatter is a document of arrays each having different no of properties. Can you please suggest a way to generate CSV file...

Reading the Merged CSV Header and Data

Is there any way to read the merged column header and its corresponding data? Please refer to the screenshot below. Do we need to unmerge the column header to read the headers? If we unmerge how to merge back to normal using the snap without directl...

Harsha3 by New Contributor III
  • 530 Views
  • 0 replies
  • 0 kudos

Excel Merger

Hi, Whether is there any way to merge two Excel data into one using the Snaplogic? Like A,B, C and D,E, F are headers belonging to two different excel Ex1 and Ex2. And I require a combined Excel concatenated side-ways like A,B, C,D, E,F Screenshots b...

Harsha3 by New Contributor III
  • 1550 Views
  • 2 replies
  • 1 kudos

Resolved! Selecting an entity from an Array

Hello, From the below Array, I am trying to get only the “error” entity which will be in any one element or multiple elements. I tried using $.result.find(x => x.name == ‘error’) and $.result.map(x => x.name == ‘error’), but in vain. I am trying to f...

Mysql ssl public key authentication

I need to connect to a MySQL instance in Google Cloud that requires username/password + SSL. This is not the same as using an SSH Tunnel, per the options in the MySQL Database Account settings. The other clients I use to connect to the database hav...

llacroix by New Contributor II
  • 1213 Views
  • 0 replies
  • 0 kudos

Insert Special character in sql server table

I have a sql server bulk insert snap which have a varchar column in table. and i have a input document to this snap having this data "• the ability to take part in daily activities " when i am inserting this to that column in the table it is insert...

ash42 by New Contributor III
  • 3451 Views
  • 5 replies
  • 1 kudos