HELP PLZ -- UNIQUE TOOL

[SaâdEnnassiri]

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

[DavidP]

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:

[SaâdEnnassiri]

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?

[ArtApa · Accepted solution]

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:

[DavidP · Accepted solution]

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.

[grazitti_sapna · Accepted solution]

Hi @SaâdEnnassiri , Is this what you are looking for?

Thanks.