I will try to summarize it very simply.
- Filter Data Table activity works very well with STRING type data.
- If you use Filter Data Table activity then you cannot play with type conversions. Also if you want to filter using conditions on multiple columns that too of different type, the output will be not the expected one. For example, you want to filter the data from excel/csv with condition like:
Age >30 and Gender = “MALE” and Height >5.5
For this situation to achieve this you have to use multiple Filter Data Table activity, one after another in a sequence
Instead, a simple way is to
- Use Excel Application Scope
- Use Read Range activity
- Use Assign activity,
var_customDT = var_DT_client126.Select("Age > 30 AND Gender = ‘MALE’ AND Height > " + var_height).CopyToDataTable
Note : var_DT_client126 is the name of my data table and var_height is a variable holding height value and var_customDT is the variable that will hold the output of select statement & its type is DataTable
So, as you can notice in a single line we are able to filter the complete data