I have problem to solve using automation. I have an excel file with four columns.
- issue status
- original due date
Current situation - Whenever someone asks what all the open status. The users opens the excel file look at the “issue status” column then get the data which are open along with other columns.
is it possible that if to automate this ? As in whenever some one ask what are all the “open status” or " over due" the bot should return the rows which satisifies this categories.
Please find below the example.
Thanks for the help,
Try using filter datatable activity
Hi @NIVED_NAMBIAR thank you.
I am new to RPA, can you please share more details .
Do this way
Use input dialog box to get user input (onstatus like whether they need open, over due etc) and store in input variable
Use read range to read the excel file and store in datatable varaible dt1
Use filter datatable activity to filter the dt1
with following data
Input Datatable : dt1
Output Datatable : dt2
Column : issue status
Value : input
The dt2 datatable contains the required the data u required.
Hope it helps you
Thank you @NIVED_NAMBIAR. Really helpful. Will try this.
Please find the quick workaround for you.
FilterByStatus.zip (9.8 KB)
Hope this helps.
Thank you so much. I will go through and let you know. Really helpful.
You can customise it as per your need
Thank you for all the help. It works nicely. Currently the output is displayed in messages. Can you please share how can i copy that in excel as a report?
I have updated the code to also generate an output excel file.
PFA - FilterByStatus_v2.zip (16.2 KB)
Hope this helps
Thank you so much. Really appreciate all the help