Hello, I’m trying to do this, I have an excel of mapping data that I need to check if each row in another data table match with a name and if It match then add a value in a cell.
(Lets call this image the mapping table)
This is the data that I need to read and if the string in C match with this other table
(this is the value table)
example - blank - Net Local Cash Sales
example2 - blank - Net Local Barter Sales
example3 - blank - Tax
example4 - blank - Revenue
sorry can’t add another image as I’m a new user, but lets say that that is 3 columns and 3 rows. and I need to compare the third column with the table on top.
Then add the value in A column on the mapping table to the value table.
the mapping is about 100 rows.so I can’t do anything small or easy like if for each value or flow decision.
the datatable that needs to compare is around 50 rows both have a column that WILL have a value that match in both data tables.
How can i do this?
I had an idea of making an dictionary and put the key as string and a value as object (like on the Robotic Enterprise Framework) and in the table of values (the second in the picture) loop with for each row and verify if a key match with the current row then add the value of the dictionary that match with the key, but I don’t know how to do this or even if its posible. I’m open for suggestions i’m lost on this part.
thanks for the help, I hope I explained what I need to do.