I have a file with names.
The first step I know how to do. First I only keep the column “Name” then i remove duplicates so I only have the names “Dave”, “Steve” and “Peter”. Now i have 3 transactions to work with.
I then want based on these 3 names to first focus on “Dave”.
Then I need to use the original file(image above) and match all the “Dave”(Yellow) and get all the information that is at the same “level”(Green)(see image below)
… into another Datatable where i will need to perform some calculations. This new Datatable will be dynamic which means that the content will change between the transactions.
After this i need to continue with “Steve” and do the same thing.
Im thinking i need to use the “For Each Row” Activity or something similar to loop through the names.
Can someone help me.