Re-attempt query

Help Studio
1

Hi Friends,

I have a query, see below screenshot.

A spreadsheet lists names with corresponding remarks on the left, highlighting specific retry messages in yellow on the right. (Captioned by AI)
A spreadsheet lists names with corresponding remarks on the left, highlighting specific retry messages in yellow on the right. (Captioned by AI)733×274 7.71 KB

We have Retry Messages If any of them comes in Remarks column, then we need to reattempt next day. These cases will be come next day and also some new cases will also come but how bot can identified which is yesterday cases and which are current day cases.

Eg- see below screenshot. Old and new cases will come but we need to delete old cases only

The image is a table highlighting names with corresponding remarks, indicating which entries ("Ram", "Kumar", "Aman", "Kapil") must be deleted and which ("Anil", "Manish") should be reattempted the next day. (Captioned by AI)
The image is a table highlighting names with corresponding remarks, indicating which entries ("Ram", "Kumar", "Aman", "Kapil") must be deleted and which ("Anil", "Manish") should be reattempted the next day. (Captioned by AI)605×218 5.71 KB

Please assist.

I am using dispatcher & performer bot in RE.

2

@Jeeru_venkat_Rao,

You can add a unique identifier create from all the columns of the row to identify if the record/transaction processed on previous day or not.

3

@ashokkarale - can you elaborate more, i did not understand it. Also I am not using orchestrator

4

With just those 2 columns, how would you - as a human - identify rows from the previous day?

5

Hi @Jeeru_venkat_Rao

You can basically add a new column say Status
If the row is retried You can update the status column by “old”
Status column will be the source of reference to the bot

Thank you! hope this helps!

6

@Jeeru_venkat_Rao,

If not using Orchestrator then this won’t be useful.

How you are differentiating yesterday’s data and new one?

7

This is the challenge part.

  1. Here we can add timestamp column
  2. We can filter these cases in new sheet and in next day we can compare it with current day file. If file is already available in old sheet then delete
8

@sudster -This is the challenge my friend. We can use some columns additionally and compare it with other file.

9

I filter all retry cases and write in new excel(Retry)and added timestamp column as well and in performer it read this excel as well. If in current excel if any keywords related to retry found then it will check in retry excel file if case found then delete.

You can correct me if my approach is not correct.