Filter excel on multiple columns

[Abudhahir]

Hi All,

I have excel it has a Value =“True” and “False”. in Column E and F and G.

I want to filter only true values by using the coding. can you help me on this.

I used this, it filter only Column E while I try with multiple columns its through error.
Dt.Select(“Coulmn E=”&Value).CopyToDataTable

Notes: I have created Variable Value='True".

[lakshman (Ganta lakshman)]

@Abudhahir

Try this:

              DT.Select("ColumnName = '"+Value.Tostring+"'").CopyToDataTable

[Jan_Brian_Despi]

Hi @Abudhahir

You can use Filter Data Table activity for that one.

Thanks and regards

[Abudhahir]

Hi Brian,

I plan to use via coding.

[Jan_Brian_Despi]

Oh okay

[Lahiru.Fernando]

Hi @Abudhahir

Try using the below code for multiple filtering

With variables
Dt.Select(“Coulmn E= '” + StringValue + "' AND ColumnName = '" + StringValue + "' ").CopyToDataTable

Without variables using hard coding
Dt.Select(“Coulmn E= 'True' AND ColumnName = 'False'").CopyToDataTable

Let me know whether it helps

[marta_zanini (Marta)]

Hi @Lahiru.Fernando,
when I try using the code with variables I got this error : Assign: Syntax error: Missing operand after ‘number’ operator.
Could you kindly help me?
Thank you

[jack.chan]

refer to this

How to filter but with dynamic columns

you can use the below instead of using filter datatable activity. You can create a variable to be passed into the argument of dt.Select() and the value of the variable can be based on the config file dt.Select("[col1]='a' AND [col2]='a'")