Long time reader, first time posting.
I’m beginner with UiPath (and programming overall) but I’ve managed to utilize the community so far to get my way.
Now I’m at point where I would need some guidance and help.
I have two different data tables, from where I would need to find the closes match and return the column name from dt1 (eg. S). Data tables share the row ID which I can use to find the correct row index.
I have “for each row in dt1” - to collect all rows.
Then I find the “row items” so that I can use "if the rowID=“row name” to find the correct row.
- How do I loop through the dt1 row values to find the closest match to dt2 value?
- When I find the match, my idea was to use the dt1 match index to check the column name on the same index, but again I would need some advice how to achieve this?
Conditions for the value match could be something like:
length +/- 5
width +/- 5
depth +/- 1
Hope someone can direct me forwar.