Hello, I'm trying to find how many appointements were not the customer 1st appointements in 2019, based only on the 1st 200 apoointements in 2019;
But I can see non-duplicate records in the D Anchor?
What I'm doing wrong plz?
Thx for your support
Hi - If I understood your task correctly, you want to know how many appointments were not 1st. Then you need to skip the 1st appointment and count the rest. Here is the workflow:
Have a look at the attached workflow. The box that says subsequent appts shows a count by customer ID of all appointments after the 1st appointment.
Hi @SaâdEnnassiri , Is this what you are looking for?
Thanks.
It's hard to investigate the problem without the input data file. Your current configuration of the unique tool will put the 1st occurrence of a Customer ID in the Unique output and any subsequent occurrences of the same ID in the Duplicate output .
Another way of separating the 1st end subsequent appointments for each customer would be something like this:
Thanks a lot David for your help, my objective was to find customers not 1st time appointements with the 1st 200 appointements in 2019.
Maybe I'm not using the correct or best tool to do so?
