Designing and Running Pipelines

Migrating Oracle Number to SQL Server Numeric

I have data I need to move from Oracle to SQL Server. In Oracle the data type is just “NUMBER”. No precision or scale specified. I know from analysis that these values are in some of the rows for one of the columns. .2010259556758395029265468931284...

How to use if else condition in xml generator snap

Hello Team how we can use if else condition in xml generator snap here is my query here either Expt have value or Sco have value not in both (Expt,Sco) i want to display case 1)if vatPer = 0.0 and if Expt tab have value then display Expt tab expe...

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?

SnapLogic - Integration Nation

Forum Posts

Migrating Oracle Number to SQL Server Numeric

How to use if else condition in xml generator snap

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

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

Rest Post for Multipart form type content type wit...