Designing and Running Pipelines

Resolved! Unique Constraint Issue in Oracle while inserting Data

In this Scenario, I have to insert data onto an Oracle DB. Before that one I’m performing a Left Outer join and separating the data (for Update and Insert) by using router. In Insert snap I have to insert all the data ,before that one Need to check w...

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

SnapLogic - Integration Nation

Forum Posts

Resolved! Unique Constraint Issue in Oracle while inserting Data

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

optional field on mapper

Help to parse Json data into csv

Updating Salesforce contact object and Account Loo...

Slicing Data from JSON

Connecting Confluent Kafka using OAuth

Hexadecimal to binary conversion

array.map if field1 meets criteria, I want field2

Filter Array data

How to create timestamps and out put them only usi...

Do JSON mapping in a single mapper