Designing and Running Pipelines

Error when joining a large data stream to a small one

Good day all, I’m getting an error when joining a large data stream (118M rows) with a smaller one (276 rows). The join is on a field called ‘column_name’ to ‘col’, and its an Inner join. The smaller data set contains data validation info (length, d...

Read/write data using adls gen2

I am trying to read and write data from adls gen2 account but not able to get it. Account is created and validated successfully. Can anybody give some example to achieve this.

DIFF SNAP issue

When i compare txt type files, everything works well with the DIFF snap but when i try to compare excel files, sometimes the column formats look different and it appears as a MODIFIED row on the report. Is there a trick to that? For example, a money ...

Integrating Snaplogic with VBA

Hi, I need to take data from 3 sources and consolidate them in the sheet post that I need to activate the VBA code which completes the work. For the first half, I employ snap to complete the task and after there are some pivoting logic needs to be ha...

File Operation snap question

I want to do the file compare (DIFF) on two files but the name changes every day with a new date. On my File Reader snap, I have put the file names in like this “smb://xxxxxx.com/us_data/Shared/MM365/Clients/Small Market/Reporting/Non-Standard_Report...

Map input array issue

array mapping in mapper My json: “Employee”: [ { “name”: “Tom Cruise”, “name”: “Robert Downey Jr.” } ] I need Output { “item”: [ { “name”: “Tom Cruise”, “age”: 50, }, { “name”: “Robert Downey Jr.”, “age”: 50, } ] } Could you please help. Age is const...

LF's in CSV to result in a Multi-Line Cell in Excel

Could use some advice here. I am trying to take a string of data (a group of key/value pairs) that is comma delimited and insert it into a single Excel cell so that it shows as multiple lines within the cell. For example, I have a data string that lo...

Upload to sftp snap

I need to begin uploading files to an sftp site. I assume I must set up the account somehow in file writer. Can you advise on how to do that? I have looked at the doc but i dont know what the words mean. i have a site and a password–sometimes i will ...

SnapLogic - Integration Nation

Forum Posts

Error when joining a large data stream to a small one

Read/write data using adls gen2

DIFF SNAP issue

Integrating Snaplogic with VBA

File Operation snap question

Map input array issue

LF's in CSV to result in a Multi-Line Cell in Excel

Upload to sftp snap

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