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.
Example:
(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.
Can you send me a guide on how to or something and thanks I will look into that as well, but if you have something that will guide me a bit more on how to use that on my case will be great help.
@rahatadi I’m having trouble understand that, what parts of the workflow should i add on mine? I edited already all of the ones that are connected to the start but when it exist the for each row it doesn’t write anything on the dtinput. and on debugging the row index always shows -1.
prashant1603765
V_Roboto_V
ashokkarale
mively
Yoichi
ppr
arivu96
Darshan_Sable
Anil_G
Chris.ro