Not Equal Column Value

[Robotics (Bala)]

Hi Team,

I am extracting specific rows from excel based on a condition.
Excel column name is
CHANNEL
AA
AB
AC
AC
AD
In assign activity using select statement i want to fetch rows which does not have the value AC
In Select trying as CHANNEL != ‘AC’ - Not working fetching all rows
CHANNEL <> ‘AC’ - Not working fetching all rows
Need help

[omer.ozturk (Ömer Öztürk)]

Hi @Robotics,

You can use filter data table activity. Please check the screenshot.

Regards
Ömer

[Gokul001 (Gokul Balaji)]

HI @Robotics

You can try with Filter data Table activity

Check out this blog for infomation

Four Ways to Filter Data Tables in UiPath Studio | UiPath

Regards
Gokul

[Robotics (Bala)]

Already i am using multiple conditions inside Select statement(assign activity) i want to include this condition as well

[Gokul001 (Gokul Balaji)]

Instead of Sing quote try with Double Quote CHANNEL <> "AC" @Robotics

[Robotics (Bala)]

No its showing error in code

[Gokul001 (Gokul Balaji)]

What was the error ? @Robotics Can you share the code here

[Robotics (Bala)]

dtInputExcel.Select(“[Opened Date]='”+now.ToString(“dd-MMM-yy”)+“’ AND [PRIORITY]=‘2’ AND [CHANNEL] <> ‘AC’”).CopyToDataTable