Designing and Running Pipelines

Child pipeline not getting executed

Hi, I am trying to use a pipeline which has two Execute Pipeline snaps, Execute Process 1 and Execute Process 2. (Picture Below) But when running this pipeline, only the first child pipeline is running and not the second one. Even though there is no...

How to add leading 0 in a particular column value to make it fixed 9 digit number

Hi All, I have a scenario in which I have to add leading 0 to make all over length as 9 of the value. If the value is of length 1 then I will add 8 zeros and if the value is of 4 digit lenght then i will add 5 zeros to make it total 9 digits as lengt...

How to use AND in expression

Hi All, I have two outputs coming from a mapper snap and I want to check some condition checks e.g. output 1 output2 A B Then route to output 1 of router snap A C Then route to ou...

Date format problem

Hi, I have a CSV file containing the dates like ‘16-DEC-2019’ and I am reading the CSV file and inserting it into an Oracle database table but it always errors out because the format desired is a date in format yyyy/mm/dd hh:mi:ss. I have used the be...

Resolved! Map expression regex

Hi, A simple one for the people that are expert in regex. I’m still learning it. So, I have a key: notes that contains a value : “#IF:SLG-01-SL + some text here” My goal is to always get the 9 characters after an ‘#IF:’ My expression I tried in the ...

Null Values Not Written to Table

My Oracle input is address information similar to: STREET: 123 MAIN STREET CITY: ANYTOWN STATE: ANYSTATE ZIP: 12345 COUNTRY: USA STREET: null CITY: OTHERTOWN STATE: OTHERSTATE ZIP: 54321 COUNTRY: CAN STREET: null CITY: OTHERTOWN STATE: null ZIP: null...

Support Issue

Hi, I have sent multiple emails to support@snaplogic.com but nobody bothers to respond. Could you confirm what it takes to get a response from you?

Join preview data different than the actual raw data

Hi Team, I’m joining 2 tables (one from snowflake and another from salesforce), I do have the raw data so that it helps me with my validation while designing a pipeline on snapLogic. While I use a left outer join, even though the data should have bee...

SnapLogic - Integration Nation

Forum Posts

Child pipeline not getting executed

How to add leading 0 in a particular column value to make it fixed 9 digit number

How to use AND in expression

Date format problem

Resolved! Map expression regex

Null Values Not Written to Table

Support Issue

Join preview data different than the actual raw data

What account should be used for API with query par...

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