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 :
...
Forum Discussion
I don’t think it’s possible to configure the CSV Formatter to do this at the moment. You might need to do something like the following to detect when there is no data:
So, on the ‘No Data’ branch, you can have a Mapper that defines the headers and a CSVFormatter that writes the document to the file. Not great, I wish I had a better answer.
I don't have a child pipeline (and I don't want one). I think the Pipeline Execute Snap only works if I was calling a child pipeline, Correct? - > Yes. You can set the pipeline to invoke itself with the Pipeline Execute Snap(and set the needed parameters), but its not an ideal solution 😄
And yes, I don't think that you can set the pipeline parameters without passing it from the parent process or external REST call.
Looking at your case, I guess your pipeline is exposed as a REST endpoint, so either:
- you can pass the InvoiceID, EmployeeID as a query parameters while calling the pipeline
- or store the parameters in a file(SLDB or any other external file locations), database table, SnapLogic Tables etc.
Thanks for your responses. You have confirmed my suspicions. It does seem a gap that SnapLogic is unable to provide business metric audit capability without not insignificant customisations.
You can utilize the Pipeline Execute Snap to call the pipeline and pass/set the pipeline parameters. In the pipeline on which you will pass/set the parameters, you can capture the parameters:
So, in the Dashboard -> Execution Status -> Pipeline Parameters, you will be able to see what have been set for the captured parameters.
I don't have a child pipeline (and I don't want one). I think the Pipeline Execute Snap only works if I was calling a child pipeline, Correct?
I am trying to achieve something like the below where Audit Invoice ID could set a Pipeline Parameter before completing.
I strongly suspect this approach won't work, I am trying to see if I can get some Audit capability out of SnapLogic without having to create special pipelines and messages which would impact performance.
