I am creating an automation in UiPath in which I do a ‘for each row’ loop on an Excel called ‘BDNS’ to extract a code that is located in a specific column. For each extracted code, I check another Excel called ‘Master’ to see if that code is already registered (and therefore already processed). If it is not processed, I perform certain actions to obtain certain information using that code and save it in variables, which are then stored in a third Excel.
My initial idea was:
- ‘For each row’ loop on ‘BDNS’
- An ‘If’ statement to check if the code was already in ‘Master’ → I’m not sure exactly how to do this part
- Then develop the steps to obtain the data
- And finally, open the third Excel to store the data
How should I approach this automation?
Hi @Carla_Munoz ,
From the Problem statement provided, we would require to check the code from each row of the datatable is available in another Table/Datatable and then perform the action.
For such cases, we do use Datatable methods and perform the operations using that to Filter / Process only the matching records.
In your case, we do not see another Datatable being used.
For more clearer picture, could you maybe provide us with the Sample data and it’s Expected Output, so we would be clear on the steps that need to be done.
Hello, what Sample of the three excel data i use, you want to se?
@Carla_Munoz ,
The Sample data is mentioned so that if you have confidential data involved, you could provide us the same data with its format but with masking of confidentiality with dummy values.
Expected Output is the transformation expected from Input data to Output data.
This would help us clear the logic required for achieving the result.
sonaliaggarwal47
mahmoud.zaky
WhatIsRpa.com
jeevith
A_Learner
Anirudh_Tugawe