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...
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...
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 ...
{"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"...
Hello Experts,Trying to create combination of records after reading excel file.number of column are dynamic.sharing expected result of screenshotCan anyone help me to achieve this.thought to use script snap but got stuck as we have dynamic column str...
I am facing a weird problem with the Join snap. It looks like the path I provide in the Left Path property is reading documents from the Right input view even though the right input view is correctly set to input1.Similarly, the path I use on the Rig...
