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 ...
{"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"...
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...
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
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...
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...
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...
Hello, I am trying to implement the RANK function similar to what we have in sql. Rows with equal values for the ranking criteria should have the same ranks and ranks might not be consecutive numbers. For example, if two rows are ranked 1, the next r...
| User | Count |
|---|---|
| 320 | |
| 213 | |
| 176 | |
| 150 | |
| 115 |
