Lookup datatable will be very fast and reliable in this case
So once after getting the datatable variable named dt
Now use a FOR EACH ROW activity and pass the variable dt as input
—inside the loop use LOOKUP DATATABLE ACTIVITY and mention these in property panel
Input - row(“value”).ToString
Datatable - dt
Lookup column name - “value”
Our result - str_output // which will be our output string variable
Target column name - “Property”
Now next to this lookup datatable across a writeline and mention as str_output.ToString which will show us the output in the output panel
@rameezimtiaz
Hello,
Send to excel your data. Put headers for your columns.
Then use Excel Application Scope for your Excel file. Read range for your sheet.
For each row in Your Output From Read Range
In the body use IF Condition
Your variable that you need to compare = row(“Column Name”).ToString Then(True statement) use Assign activity and make something like newVariable = row(“Column”).ToString Else(False statement) let him to be empty or put delay for one second.
Example how I foreach each row to find password. I’m comparing usernames.
if it more than 50 rows also possible if it is like key and value pair then you can go with dictionary.
if values are coming from excel then use a loop to add all the value to dictionary (same method used in REframework) then it is very easy to retrieve the values from it
Hi @rameezimtiaz
If you want to get the value from Value column considering the value of another respective column. then use following Linq Code. YourdataTable.AsEnumerable().Where(Function(j) CStr(j("ColumnToValueSearch")).ToString.Trim.Equals("Value")).Select(Function(x) cstr(x("ColumnToGetValueFrom"))).ToArray
This will give you Array of String.
I hope this will help you.
Regards
@Palaniyappan@rameezimtiaz
For each the table Build Data Table.
Comparing from the specific column.
Assign if the values are the same.
Using message box to show the result it’s working.