How to handle null or empty element
Hi, I need to use null and empty condition in router. curretnly i am using:- $ZSDATA.IDOC.EDL2.EDL4.BEL != “” but i feel i am not handling it correctly. Any inputs?
Forum Posts
REST API Paging Issue
Hi, I have a REST API where the page index is passed in the request body. There is no indication of total records, so you must increment the page index in the request body until no records are returned. I cannot see how to do this via the pagination ...
Performance Improvement - Loading large CSV files to Snowflake
I have a use case to load some large CSV files (in GBs) from windows network drive to Snowflake. Used a CSV parser and loading it using Snowflake bulk load. Pipeline is running without any issues. However, it takes a lot of time to load the data. Is ...
How to create a report on Tasks Invoked by Specific User in SnapLogic?
Hi Everyone,I created a user with administrator privileges to invoke pipelines in a project using a username and password. However, I now want to reduce the user's role to a lower level.Before making this change, I want to ensure it won't disrupt any...
Get order of records within a group
I have a situation something like this: Employee IDEffective DateOffice11/1/2023San Francisco11/1/2024Oakland26/1/2023Sydney212/1/2023Tokyo I need to add an order column and end date of the previous record column. Can you please suggest any ways of ...
Using Workday RaaS to Extract Data
Using Workday RaaS to Extract Data Workday has a Reporting as a Service (RaaS) interface which allows you to export most data from Workday by creating a custom report within Workday then exposing it as a web service. The output can be various format...
How to split files based on size(less than 20mb per file) when writing into S3
Hello,I need to write files into S3 by keeping file Size(<20mb) ,rather than giving number of records batch limit using pipeline execute. My input is dynamic sometimes 1k records write file >20mb , sometimes 10k records is <20mb. We also have batches...
Resolved! how to filter out spaces
How do I remove spaces from the output ?Output of this pipeline is [ {"lrs": ["Indiana","Alabama",""] }]
