For example, I am having a column “status”, in that particular there are so many possibilities of name may come such as TATA or tata or Tata. In that column how I can change the entire column to lower or upper in order to use the filter datable. Please let me know how to resolve this.
Use below expression in Invoke Code activity.
InputDT.AsEnumerable().ToList().ForEach(Sub(row) row(“status”) = row("status").ToString.ToUpper)
Note: Create one argument for Invoke Code activity and mention properties as below.
Name - InputDT
Direction - In
Type - DataTable
Value - InputDT
Try with below steps
Read Range the excel
Iterate through For each row
Assign Currentrow(“status”)= Currentrow("Status).toString.ToLower Or Upper
Then Out side the loop Use Filter datatable with filter Value.
FYI, another solution:
We can filter datatable with case insensitive using LINQ and String.Compare method, as the following.
dt = dt.AsEnumerable.Where(Function(r) String.Compare(r("Status").ToString,"TATA",true)=0).CopyToDataTable
I am receiving the below error sir and attached my xaml file for your reference.TestinguppertoLower.xaml (5.6 KB)
I have created a sample work flow based on your use case !
Refer to the xaml below !
test_1.xaml (6.7 KB)
Thanks@pravin_calvin. It works for me.
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.