Designing and Running Pipelines

Resolved! Get minimum date from set of column values

Hi, I have a typical requirement, where i need to find the Min ETL run time from below set of data. I tried to convert rows into columns but there is no common field to do group by. i tried different options but nothing worked for me The desired ou...

Duplicate data using SQL offset

We are attempting to load transactional tables on a pipeline we created Issue faced - While loading data from a transactional table by leveraging the help of limit and offset in SQL SERVER select snap (partition and loading), we are getting duplica...

Can snaplogic listen to external events

Hey, there can snaplogic listen to external events?

Pipeline Details with dependency from Dashboard

Hello Everyone, I have a requirement like there are aprox 500 pipelines are running already in production environment and every pipeline is calling multiple pipelines inside it to achieve the functionality. I have to create the excel spreadsheet whic...

Decrement a dynamic value per record, move to next match if value=0

Hi all, I am looking for a way to decrement a dynamic value (number of seats per faculty member). I am using a Join to match students to a faculty member, then grabbing the first match by Grouping the values into an array and grabbing the first eleme...

Resolved! Can't apply date functions to a date column

Hello, I get “Unknown method” when applying any date-related snaplogic function to a column that is a local-date-time. I tried this with two separate clients with different schemas and data types, still same issue. Is this a bug?

To check if matching records have different value in other column

Hi there, I have 2 excels fiels, source and destination. each one has 3 columns, Id, Quantity, last modified date. I need to find if there’s a matching record by Id but has different values in Quantity, then use record that has different value to up...

Take upstream file as an input for zipfile read snap

Hello, I am getting a zip file from a rest request. I want to rename files (files we get after we extracting the zip). I don’t want to write the zip file in sldb and then read it using zipfile read. I want to directly use file coming from upstream in...

SnapLogic - Integration Nation

Forum Posts

Resolved! Get minimum date from set of column values

Duplicate data using SQL offset

Can snaplogic listen to external events

Pipeline Details with dependency from Dashboard

Decrement a dynamic value per record, move to next match if value=0

Resolved! Can't apply date functions to a date column

To check if matching records have different value in other column

Take upstream file as an input for zipfile read snap

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