Good day. How to build workflow logic to collect data from excel? it is necessary to collect statistics from 4 columns: customer, cardID, sumOrder, billTime.
warning if (write to report):
-customer has more than 1 cardID
-cardID has more than 1 customer
-sumOrder from 1 to 1500 with one customer & cardID more than 2 & count record of billTime within 1 calendar month is more than 3
Hi @mf211 and welcome to the forum.
At first glance, this sounds like a job for several nodes - in particular the Excel Reader, GroupBy, and Rule Engine - with some Date&Time processing mixed in.
If you can post a dummy dataset, that may inspire folks to help you build the workflow.
This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.