hello ,
i have a senario where i need to compare the string value i fetched from queue with each and every row present in an excel file if there is an exact match set flag to true
Hi!
This should do it.
Statement in If-condition = CurrentRow(“columnName”).ToString.Equals( MyString)
@sanjay_gowda Yes We can achieve this just provide a sample of input excel and specify which column we have lookup and string value as well.
Regards,
Ajay Mishra
1 Like
hi @sven.wullum1 ,
is there any linq querry for this becz for each is taking a lot time as i have more than 1 lakh rows in my excel
Sure!
You could even use the filter datatable activity, or a select statement.
For figuring out the linq query I suggest you use chat-gpt or the built in co-pilot in EDGE to assist you.
Hi ,
→ Read Excel File and store in a dt
→ use LINQ to compare each row in the DataTable with the string value fetched from the queue.
→ If there’s an exact match, set the flag to true.
dt.AsEnumerable().Any(Function(row) row.ItemArray.Any(Function(cell) cell.ToString() = “sneha”))
replace “sneha” with the string value
This approach avoids explicitly mentioning column names, as it checks every cell value in the DataTable for a match with the string value from the queue.
You can use this LINQ in assign activity.
intMatchCount = dtInput.AsEnumerable().Where(function(r) r("Column Name").Equals(MyString)).Count()
Thanks,
Ashok 