Designing and Running Pipelines

Resolved! Joining hierarchical data

Hi, I have an excel with the data in the below format Rows at level 1 is a parent to the next subsequent rows at Level 2. For ex: Development (row 2) is parent to Java, dotnet, php (rows 3,4,5) Testing (Row 6)i s parent to Manual, Automation, Load...

Architecture: Pipeline Execution Mechanism - Some Questions

How does the SnapLogic Control Plane identify a specific node in a Snaplex for executing a pipeline? How does it identify if a node is busy? Is it only checking one time for the node’s availability? This is a continuous process: When a node is fired ...

Extract attribute value from XML input usin g Mapper Snap

Hi , I am trying to get attribute value from an xml input to store in a variable in snaplogic. What is the syntax for that ? e.g XML Input More Input here i want to capture "123" in variable using mapper snap. Please help with the...

Is there a better way to calculate a value and use it throughout a pipleine?

Hi, often I have a need to calculate a value and then use it several places throughout the pipeline. It gets a little ugly, because using pass-through, I often end up with something like $original.original.original.original.THISTERM. Is there any b...

Query in the Sequence Snap

Hi Good day, I have developed a simple snap which takes the difference between the start date and end date from the source . If the difference is 0 then the output prints either start or end date due to same value . On the other hand if the differen...

Csv to json

I am able to convert csv to json. But with some csv they contain escape character in column value(), due to which it is giving error. Below is the sample csv content, you can just copy and paste in notepad and save it as .csv Please advice the correc...

Kubernetes for snaplogic

had a question about the snaplogic helm chart for k8… trying to start up the containers but they stall on pending… all nodes in the cluster have enough resources available: 12GB RAM / 2CPU cores. aseadmin@ase-s1-k3s-sqlb1:~/.kube/snaplogic$ kubec...

How to fetch matching records where columns matches in two separate excels?

actually i have two excels where one is static and other is dynac where need to fetch values matching on 3 values from static . select * from static where colum1=(select columns 1 from dynamic) and colum2=(select columns 2 from dynamic) and column3 =...

SnapLogic - Integration Nation

Forum Posts

Resolved! Joining hierarchical data

Architecture: Pipeline Execution Mechanism - Some Questions

Extract attribute value from XML input usin g Mapper Snap

Is there a better way to calculate a value and use it throughout a pipleine?

Query in the Sequence Snap

Csv to json

Kubernetes for snaplogic

How to fetch matching records where columns matches in two separate excels?

Error pipelines and pipeline execute

records to json file

Combine CSV document into a new file

Only execute child pipeline if BigQuery result is ...

Create a date range by hour

SOAP execute snap vs REST post/Http client snap

Transpose columns(Dynamic) into rows.

Is migrating of REST Snap to Http Client still man...

Change all Keys in JSON structure to lowercase

How to read .xlsb file