Designing and Running Pipelines

Reading Source file and target file and mapping data from source file to target file

Hi All, We have a requirement to read the data from source file and map it to target file where as the target file has to be taken as input file to read the structure(target columns) as target file structure is dynamic. Ex: Source File has columns A ...

Getting Snap aborted error when executing script file

Snap was aborted Hide Details… Script[5d35a4b567ad1a03d5af51a6_8067c2d5-703e-432b-a5aa-3dfe73595b42 – 99f07565-a279-430f-9660-184162b1c909] com.snaplogic.cc.snap.common.ThreadDetails: Waiting to receive data from s3.amazonaws.com/XX.XXX.XX.XX:XXX at ...

Mapper snap showing extra elements

In a pipeline custom snap is connected to a mapper snap. In the below screenshot left hand side is the data preview of custom snap and on right the input schema of mapper. The mapper is showing me the elements(as highlighted) that are not present in...

Queries in merging two tables

Good Day, We need to perform a simple activity where I used outer join and merge . The purpose of merge is to actually unite both the tables to proceed further . Since the entries present in the result table are not in source table , there are null e...

Most Efficient Way to Copy Values From Parent Object to Multi-Instance Child Object

Hi, I’m looking for the most efficient way to copy values from a parent object to a multi-instance child object. For instance, if I need start and end dates from an order header on the order lines. I should also add that I’d like to rename some of t...

Resolved! Valdiate Pipeline Execute

Hi everyone, I’ve been wondering if, when validating pipelines, there is any way to jump into pipelines which were run with a Pipeline execute to review the individual snaps? So far i’ve been taking the output of the initial pipeline, stage it in the...

How to set alert when any task is disabled

Hi Team, We had a situation where if a tasks is disabled we are not aware of it. Can we set any alert that when tasks is disabled we receive an email. Regards, Hirak

How to avoid Reading Data File Multiple Times

Hi, How to read the file only once and perform multiple validations on the file. Example: My file has 20 columns and I want to find the count of 4 different columns (Column1, Column4, Column9 and Column19). I have the logic to get the count built in ...

SnapLogic - Integration Nation

Forum Posts

Reading Source file and target file and mapping data from source file to target file

Getting Snap aborted error when executing script file

Mapper snap showing extra elements

Queries in merging two tables

Most Efficient Way to Copy Values From Parent Object to Multi-Instance Child Object

Resolved! Valdiate Pipeline Execute

How to set alert when any task is disabled

How to avoid Reading Data File Multiple Times

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

Parsing CSV file

Data Validator Pattern error