Designing and Running Pipelines

Parent pipeline executing different child pipelines based on condition

Hi, I have an existing parent pipeline that calls a child pipeline. I have to add another call to another child pipeline. I have to update the parent pipeline so it can call any of the two different child pipelines based on conditions. I tried to use...

How to truncate data with BigQuery Snaps

How do I truncate date from a BigQuery Table using the BigQuery Snaps?

Is there Upsert Capability for BigQuery

Hi, Is there Upsert capability for any of the biqquery snaps?

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

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

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

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

SnapLogic - Integration Nation

Forum Posts

Parent pipeline executing different child pipelines based on condition

How to truncate data with BigQuery Snaps

Is there Upsert Capability for BigQuery

Resolved! Create statements based on the count

Writing flat file

Reading the Merged CSV Header and Data

Excel Merger

Resolved! Selecting an entity from an Array

How to dynamically update an account?

Execute each child pipeline multiple times

Routing files from S3

Clean duplicated lines in CSV datasource

How to get all values of a key from objects in a l...

The "Pipeline execute" is changing data types?

Remove XML duplicate key from JSON list in XML for...

Generating individual files based on 'n' records f...

Convert array with objects into object with key/va...

Converting a string to JSON doesn't work