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

Forum Posts

Resolved! Create statements based on the count

HI , We have a requirement where , we hit api and get the count. Based on the count we need to create some sql statements. for example if count is 500 we to create a statements like below select * from table where columcount between 100 and 200 selec...

sravan by New Contributor II
  • 1522 Views
  • 2 replies
  • 4 kudos

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
  • 589 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
  • 1825 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
  • 1383 Views
  • 0 replies
  • 0 kudos