Designing and Running Pipelines
Discuss how to use the SnapLogic platform.
cancel
Showing results for 
Search instead for 
Did you mean: 

Forum Posts

How to flatten hierarchial JSON structure?

Hi Forum, I have hierarchical JSON structure coming as input and need to flatten(and transformation) the document as output. Below is the simple example showing input and output structure. I tried doing this with Mapper, Strcuture and JSON Splitter s...

ddangler by New Contributor III
  • 5261 Views
  • 3 replies
  • 3 kudos

MySQL Insert Can't Insert Special Characters

Is there any way to encode strings or perform a MySQL insert on a special character like ł or Ł. I can’t get it working, but it works just fine using another ETL process. In my specific use case I’m trying to insert names that include special charact...

nsmith by New Contributor III
  • 12895 Views
  • 5 replies
  • 1 kudos

Mermory Utilization of Specific pipeline

I have a requirement of calculating total memory that it consumed by a specific pipeline during it’s run time. Can we use Public API with RuntimeId of that pipeline to figure out the utilization of total memory for a specific pipeline. Thanks!!

aspanda by New Contributor II
  • 2301 Views
  • 1 replies
  • 0 kudos

Resolved! Dynamic records generation

Hi, I want to generate dynamically n records, based on column value. Lets say based Number_Streams , I want to create n records having same values for other columns, except the name. In name column I want to append alphabets dynamically. Sample Input...

Append/Merge input fields into single field

I have list of fields with name like, amount_1amount_2amount_3amount_4… I need to map all the amount fields value into amount column in target. Example: Note: the fields is dynamic we can get “n” number of fields. Looking forward any inputs/suggest...

Surendar by Contributor
  • 3188 Views
  • 1 replies
  • 0 kudos

Resolved! BUG OR ERROR : Date UTC Method

Hi All, I am using Date.UTC() method to generate last month date & using below syntax which seems to be fine. Date.UTC(Date.now().minusMonths(1).getFullYear(),Date.now().minusMonths(1).getMonth(),0) And output preview is also fine. But while I am ...