How to add 2 columns data into queue using UI path

[Logical_Places]

Hi Team,
I have one Excel with 2 coulmn data .so I need to add the data into queue using UI path.

Attached is the screenshot for your reference.

We don’t know in which cell data is there .
If data is there in Excel whether it is invoice number or account number I need to add all the data in to queue.

If the data is invoice number we need to add invoice number to queue.
If data is account number need to add account number,from data and to date to queue.

I want use to alla the data in future so , data will be added one by one
If 1st data is account number need to account number,from and to date .
2 nd dats is invoice number need to add invoice number as 2 nd transaction like that.

Please let me know if any solution.

Thanks in advance

Regards,
logical places

[adiijaiin (Aditya Jain)]

hi @Logical_Places

Welcome to the Community!

You can add all the data into queue row by row and later on while retrieving the data you can check whether if invoice number is empty or not, or Account Number, Date From and DateTo is empty.

or else in the Dispatcher code itself you can check if String.IsNullorEmpty(row(“Invoice Number”).ToString)
in the then add queue item and only provide invoice number as in argument.

The same way you can check for String.IsNullorEmpty(row(“Account Number”).ToString)
In the then section, add queue item with account number from and To Date.

But make sure in the second approach you check the values retrieved in Performer part of the code.

Thanks

[Logical_Places]

Hi @adiijaiin ,

Thankyou for quick response.

I need to try and let you know the results.
Thanks.