Designing and Running Pipelines

Converting Varchar data into Datetime

Hi everyone, I’ve been trying to convert data I’m receiving from a varchar (20171211 125023) into a datetime (2017-12-11 12:50:23). I’ve been messing with the mapper but I feel like I’m at a road block now. I was wondering if someone in the community...

Group and Sum in Expression Language

I am trying to group and sum an amount by two properties with the expression language with no luck. I tried using the reduce function, but it’s not working like it does in traditional javascript. Is there any way to get this to work? Here is my inp...

Redshift and SnapLogic

We are trying to stand up a new Redshift environment and want to be able to connect and run pipelines with SnapLogic. Corporate security rules require us to launch the Redshift cluster in a private subnet, no NAT or Internet Gateway, all access throu...

Resolved! SAP IDOC write how to set snap SAP IDOC to Asynchronous mode

Hi , Hi Team, I created one pipeline which writes an IDoc to SAP using SAP IDoc Write Snap. I need to know how to set SAP IDOC to Asynchronous mode?

Compare current to previous document in stream

If I want to compare two consecutive documents in an ordered stream (compare the current to the previous or next), is the best way to do that with array indexing functions in mappers/conditionals?

Hi All , I am new to snap logic , I have a requirement that needs to Read data from text file and load into snowflake table , what are the snaps i need to use to build a pipeline

Date conversion

Hi , I am having a source csv file which contains the date in the format dd-MON-yyyy ( say for example 01-JAN-2020 ) . I need to convert this data format to the form yyyy-mm-dd ( say 2020-01-01 ) . I have tried using various methods to parse the date...

Groundplex - Windows Service Account Settings

Can someone share how a Windows Service Account needs to be configured to successfully run a groundplex and see it appear in the controlplane. We have installed a groundplex which shows up in the controlplane if we start the groundplex using the jcc....

SnapLogic - Integration Nation

Forum Posts

Converting Varchar data into Datetime

Group and Sum in Expression Language

Redshift and SnapLogic

Resolved! SAP IDOC write how to set snap SAP IDOC to Asynchronous mode

Compare current to previous document in stream

Hi All , I am new to snap logic , I have a requirement that needs to Read data from text file and load into snowflake table , what are the snaps i need to use to build a pipeline

Date conversion

Groundplex - Windows Service Account Settings

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