User Profile

vineesha

Employee

Joined 7 years ago

15 Posts4 Likes1 Solution

View All Badges

User Widgets

Contributions

Re: Pause for 10 to 15 minutes to trigger
Hi, Below is the sample pipeline that can be used to delay time. Right now this pipeline has delay time of 89 sec, you can change that according to your preference.sleep_2021_01_29.slp (3.7 KB)
5 years ago Place Designing and Running Pipelines
2.8KViews
2likes
0Comments
Re: How to Sort an Array Based on Key/Column name
Hi, You can use the expression that’s in the mapper in the attached pipelinesort_2021_02_03.slp (3.5 KB) to sort the the elements.
5 years ago Place Designing and Running Pipelines
2.5KViews
0likes
0Comments
Re: How to access a field in Child Pipe Line
Hi, attaching the pipelines for your reference that work both with eval and JSON.parsetest child properties_2021_02_01.slp (5.1 KB) mapper_2021_02_01.slp (3.8 KB) let me know if you have any questions.
5 years ago Place Designing and Running Pipelines
3.4KViews
0likes
0Comments
Re: Download Pipeline
Hi, below is the example of a pipeline which reads the list of the pipelines in a project and creates them in the specified org/project space/project. basic metadata pipeline_2021_01_26.slp (8.0 KB)
5 years ago Place Designing and Running Pipelines
3.1KViews
0likes
2Comments
Re: Unable to execute Redshift Script with comments in it using Redshift Execute
Hi, the following example would give an idea on how to write the comments, the comments should be enclosed in double hyphens(–)
5 years ago Place Designing and Running Pipelines
2.3KViews
1like
0Comments
Re: Cache Issue & In memory issues in Ultra
Did you try having the In-memory lookup snap in a child pipeline? As it provides Limited support in Ultra Pipelines when the Single document output field is selected.
5 years ago Place Designing and Running Pipelines
2.4KViews
0likes
0Comments
Re: Cache Issue & In memory issues in Ultra
Hi, is the Single document output checked in the in-memory lookup snap settings?
5 years ago Place Designing and Running Pipelines
2.4KViews
0likes
2Comments
Re: Using Oracle Execute to run complicated SQL Select not returning any data
Hi, For the comprehensive scripting functionality you should use stored procedure functionality in the Stored Procedure Snap.
5 years ago Place Designing and Running Pipelines
3.8KViews
0likes
0Comments
Re: Using Oracle Execute to run complicated SQL Select not returning any data
Hi, i’m attaching the screenshot of a simple pipeline using oracle execute and csv formatter. After you drag and drop the CSV formatter make sure the output view of oracle execute is connected to the input view of CSV formatter as shown in the picture. attaching the settings of oracle execute snap let me know if you still have issues.
5 years ago Place Designing and Running Pipelines
3.8KViews
0likes
0Comments
Re: How do you keep only one record of duplicated records?
okay, then you can use group by snap to group by ID and map required fields. attaching the sample pipeline and the data. readCsv_2021_01_19.slp (7.6 KB)
5 years ago Place Designing and Running Pipelines
1.1KViews
0likes
0Comments