Hi everyone,
in the given file
for particular order id
i want to pick the status of latest time stamp but if the latest time stamp status is “failed” i have to chek whether the old time stamp have “capture” status or not if that is available i have to pick that one for particular order id
You can start with “Group loop start” node in which you can process the order id. in the loop use
“Group by” node to make groups of order id and status in the manual aggregation you can extraxt (with maximum method) the maximum timestamp for each status. To choose the right one you can try with Rule engine.
Hi @hashim980 , it would be easier to elaborate and even show the logic if you provided some sample data to work with.
We cannot copy the data from a screenshot. We have to manually enter these values, and for what you are asking, we would need to use quite a few records, so that is asking us to do manual data entry. I am sure this is what’s preventing a lot of people from participating.