I have one input value inputStr which i want to search in column “HRname” if exist then update column Status as result1Str else result2Str and column reference as referencestr.
Suppose required all strings are
Column Name- HRname
result1Str- “HR name found”
Note- given required values can be changed and Dt contains more than 50 columns i have just provided 5-6 columns.
It consists more than 50000 data so required different approach.
give a try on get it computed by defining the datacolumn expression for the remark column
Expression would look in a direction like:
"IIF([HRName]='" & strCheckVar & "', 'YES','')"
Find starter Help here:
DCExpression_SetConditionalValue.xaml (7.0 KB)
How to check contains condition i have data with extra part.
What if input string is only Axis…so i want contains property.
then it is a different requirement. So just clear all requirements to a final set. Based on this we will check the solution approach options
Here previous solution is working for only if no duplicate values found in input column but there will be duplicate values.
Like input value is PM which i want to search in both EmpDesig column as well in ManagerDesign column.
Pm already added in dictionary of tuple key it is giving error.