Queues Compare with Excel Values

Help Activities
, ,
1

Hi Team,

I am quite new to Uipath. Need some the below information

  1. How to get the values present in a queue (say contains 50 Account Numbers)
  2. Another excel contains 60 account numbers i need to compare these 50 account numbers(in queue) with 60 account numbers(in excel) and return the 10 left out account numbers.
    If someone provide step by step details would be more helpful
2

Hi @Robotics

To get values from queue, you can use Get Transaction Item activity. Then you can compare with values with excel (Read range activity).

Thanks,
Saranya K R

3

Hi @Robotics You can follow these steps in below workflows

image
image796×546 16.3 KB

4

That’s not how queues are used. Queues are used to get the items one by one and do something with them. So what you’d want to do is a transactional automation (there’s a template for this) that gets a queue item, compares it, does whatever else you need to do, then marks the transaction success or fail, loops back around and gets the next transaction.

5

I want to extract all those transactions irrespective of the status is New, Successful, Failed.
Will this Get Transaction Item works?

6

Get Queue Items activity would help in your scenario to get all queue items.

7

Then use Get Queue Items, loop through them and compare each to the Excel (which you’ve read into a datatable).

8

Yes got the result. In queues under Reference Number we got the account number like

12345_02/11/22
22345_02/11/22
33345_02/11/22
42345_02/11/22
02345_01/11/22
92345_01/11/22
82345_01/11/22
Is there any option to extract only those records uploaded on 2nd november?

9

Any updates on the above query?

10
  • From - Filters transactions by the minimum creation date. It accepts DateTime values.
  • To - Filters transactions according to the maximum creation date. It accepts DateTime values.

From and To property would help here.

11

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.