Need help to automate the task

[Gaurav0001]

Hello,
I need help on to automate the task.

I have a .TXT file which contains the Client ID, Amount and Dates.
I need to automate in such a way so that I can get an output file in Excel with different Client ID as Sheet names, Each sheet contains the column Client ID, Amount and Dates.
If we use the different .TXT file which contains similar data, it should add automatically in respected sheets/rows.
The dates are different for different Clients, Like some client gets the amount everyday, Some Client get once in a month and Some clients get once in a week.
I need to find that we should not miss any dates.
for example., 

Client ID	P-Date	Amount	PR- Date
100_ABC	01/01/2024	1000	01/02/2024
100_ABC	01/02/2024	100	01/03/2024
100_ABC	01/03/2024	1001	01/04/2024
100_ABC	01/05/2024	1003	01/06/2024
100_ABC	01/06/2024	100	01/07/2024

So in above table, we can see the date 01/04/2024 is missing,
So it should automatically pops up when the next date enter and we miss the previous date. It should export it into an excel and  in a summary sheet it should contains the data with missing date, so that we can identify from there that which dates we miss for which client.

I have attached .TXT file and the excel files contains data for different Clients.
You can clear the excel data and use it in Alteryx.

[binuacs · Accepted solution]

@Gaurav0001 One way of doing this