Add a snap to execute a SQL Sever stored procedure
I am trying to add a SQL Server Stored Procedure snap, but it will not connect to the existing snaps in the pipeline? What am I missing?
Forum Posts
Export All Pipeline Information
Hi Community, Is there a way to export information on every pipeline or specific pipelines? I want to create an external system to search for certain configurations or text within snaps of a pipeline (i.e. a query used in a SQL Server snap). Is this ...
Split the Arrays inside a JSON object with as many rows as there are objects
{"Region": "Asia Pacific","Office": "Australia","Location": [{"name": "Brisbane","Latitude": "-27.4690555","Longitude": "153.0286812","OfficeAddress": "Suite 4, L20 10 Eagle Street,Brisbane, Queensland, 4000,Australia"},{"name": "Canberra","Latitude"...
Resolved! Parsing the string as a csv
Hi, I want to parse my dataset which is coming out as a string. Here is the example of the dataset [“field_name1,field_name2,field_name3,field_name4,field_name5,field_name6,field_name7\nValue1,Value2,Value3,Value4,Value5,Value6,{Val7.1:val,Val7.2:val...
Express Library date with timezone returns null value
Hi @RogerSramkoski i'm trying to get today's date and time in PST timezone, but it gives me null. Can you plz let me know how i can fix it?Thank you so much
Adding system datetime when insert data into Redshift
Hi,I've added mapper expression to add system datetime when I insert data to Redshift table.It ran ok, but the problem is, it inserted different time for each rows.How can I get date and time that only shows only one same date and time (either pipeli...
Append duplicate values with numbers in sequence
I have a JSON that has Associate IDs and Attachment IDs. I want to sequence the duplicate attachment IDs for each associate starting with the second duplicate ID, something like '-1', '-2',...Please refer to the sample INPUT and OUTPUT JSONS attached...
How To Generate Rank with Partitions
Hi I need to generate the rank for the below data where data should be partitioned by No and Date order by value and want to get the top 3 ranked categories for each No and each Month. Input : No Category Date Value Rank 1 Dog 01-01-2022...
