Designing and Running Pipelines

Designing and Running Pipelines

Discuss how to use the SnapLogic platform.

Forum Posts

Sorted by:

Start a conversation

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

Mapping source to target columns

Hi All, We have two input files source and target with different number of columns in both files. We need to map the source column to target column and the sequence of columns in source file is not same as target file. Any inputs on how to do this ?

Replace Values in a file from Mapping Sheet

Hi All, I’m looking for an approach to generate a transformed file where column values will be replaced with Target values from a mapping sheet dynamically. So there will be two input files-1.Extract ,2.Mapping(sample below) Extract: BU VENDOR ...

Convert UTC date to date

How do you convert this date “2020-09-01T00:00:00.000” to this “20200901”?

Top Kudoed Authors

User

Count

322

226

179

153

116