ahouston
New Contributor II
Joined 5 years ago
User Profile
User Widgets
Contributions
Help With Reduce Function in Mapper
I'm having trouble using the reduce function in a mapper which will subtotal two values across a two field compound key. For example, take the following input: "myarray": [{ "key1": 1, "key2": "A", "value1": 5, "value2": 10 }, { "key1": 1, "key2": "A", "value1": 10, "value2": 20 }, { "key1": 2, "key2": "A", "value1": 15, "value2": 30 }, { "key1": 2, "key2": "B", "value1": 20, "value2": 40 } ] My desired result is as follows: "myarray": [{ "key1": 1, "key2": "A", "value1": 15, "value2": 30 }, { "key1": 2, "key2": "A", "value1": 3, "value2": 30 }, { "key1": 2, "key2": "B", "value1": 4, "value2": 40 } ] Unfortunately due to use of an ultra pipeline, I cannot use a Group By snap and must resolve within a mapper. Appreciate any guidance from the community on how to best solve this. Thanks!1.5KViews0likes1CommentRe: Time difference calculation excluding weekends
I really like the approach taken although this doesn’t work when difference is one or two days and target start is a Friday. For example: { “startDate”: “2022-01-28”, “endDate”: “2022-01-31”, <<2022-02-01>> “targetStartDate”: “2022-02-04” } In these cases, the filter range and and and index get out of alignment. Is there an elegant way to solve? I’m building ternary operations for each exception but thinking there has to be something cleaner.4.4KViews0likes0CommentsTime difference calculation excluding weekends
Does anyone have a pattern available to determine difference between two timestamps and add the duration to another timestamp, both of which calculations would exclude weekends? For example, three inputs and one output: Baseline start timestamp Baseline end timestamp Target start timestamp Logic would find the time diff between 1 and 2, excluding weekends and add that time to 3, excluding weekends to land on target end timestamp. For example, using reference range of last Friday 1/28 until Thursday 2/3 and target start of Friday 2/4. The 4 day difference would be calculated and added to 2/4 - excluding the coming weekend, result would be Thursday 2/10. Thanks! AdamSolved5.7KViews0likes5CommentsAsynchronous REST POST Functional Response
Hello all, New user here. Could someone please provide an example of how to model handling of an asynchronous callback to a REST Post call? Do I define this within the pipeline from which the Post call is made or do I need to set up a dedicated response handler pipeline? Would this be done via triggered task or do I need to create an API? Any guidance/examples would be much appreciated! Thanks, Adam1.9KViews0likes1Comment