Excel Automation - Data extraction

Help Studio
, ,
1

Hi,

I have an excel sheet which looks like this:

The image shows a screenshot of a spreadsheet detailing roles, modules, and associated permissions for GC and PR systems with tasks like "Change control," "Task," and "Investigation Task." (Captioned by AI)
The image shows a screenshot of a spreadsheet detailing roles, modules, and associated permissions for GC and PR systems with tasks like "Change control," "Task," and "Investigation Task." (Captioned by AI)1684×562 119 KB

I will be getting a value in a variable from some application, that is Role = “initiator” for example( it can be any value)
Also i will be getting Modules = ("capa’, “complaints”) in a variable ( it can be any number of modules).

So if the Role “Initiator” is found in excel, associated module should be “RCI” and extract data from GC and PR column values and keep in seperate variables in First iteration,(First iteration because Modules variable has two values RCI and complaints), after extracting PR values, bot has to iterate through its values if it contains more values, for ex in screenshot:(system user, assignee),each item will be used in click activity so!

Then next iteration which is Complaints module.

and so on…

Can anybody help me build this logic in UiPath please?

2

Hey @Geeta
You can find a sample project with a conceptual solution for your issue here:
BlankProcess3.zip (5.0 KB)
I hope this helps!

The image displays a UiPath workflow involving a nested loop to iterate through data tables and , checking conditions for matching roles and modules, and assigning a value to . (Captioned by AI)
The image displays a UiPath workflow involving a nested loop to iterate through data tables and , checking conditions for matching roles and modules, and assigning a value to . (Captioned by AI)857×853 27 KB

The image shows an automation workflow diagram with conditions and assignments, involving the manipulation of current row values, splitting strings, and iterating through arrays. (Captioned by AI)
The image shows an automation workflow diagram with conditions and assignments, involving the manipulation of current row values, splitting strings, and iterating through arrays. (Captioned by AI)882×902 32.7 KB

This image depicts a workflow sequence in UiPath Studio, showing nested If-Else activities and a variable list configuration at the bottom. (Captioned by AI)
This image depicts a workflow sequence in UiPath Studio, showing nested If-Else activities and a variable list configuration at the bottom. (Captioned by AI)1942×940 43 KB

3

Thank you so much @pikorpa , it works great

4

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