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
Forum Posts
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...
Implementing RANK function
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...
PDF Formatter - Input Data Example
Are there exampes using the "Input Data" field of the PDF Formatter? The documentation says:Input data: String/Expression Select the specific data from the upstream Snaps that you want to be included in the PDF. If left empty, the entire upstream da...
Asynchronous execution - The root pipeline execution is no longer running?
Scenario: Pipeline1 List directory for documents. Output: e.g. 200 filenamesPass every filename to Pipeline2 asynchronously Pipeline2 (will be started 200 times) Get filenameRead fileand so on… The goal is to decouple Pipeline1 and Pipeline2. I just ...
Split an object Array into multiple rows with another array inside.
{"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"...
