How to apply filter on a data table

  • 149 Views
  • Last Post 08 April 2019
pankaj.yadav@technobraingroup.com posted this 03 April 2019

I have few doubts while filtering the Excel data, I have the scenario as below.

  • I have Multiple columns in the excel file
  • I want to apply a filter on two columns at the same time, for example:

  • In the above image data I want to apply a filter for columns  “Start Time” and “End Time”, Saying that get the data only between 3/7/2019 to 3/18/2019.
  • So after applying the filter I should get only the three rows from the above data table. That is only the first three rows.

 

I tried using excel and data table connector components, But I am not able to get the result.

Could you please guide if we have any component where we can apply the filter and get the filtered result in a data table.

 

Swathi Muppalla posted this 08 April 2019

 

Hi Pankaj,

Thanks for your interest in INTELLIBOT!

You need to use  Table Connector in order to filter and sort data. Table Connector supports this feature by using the "Filter and sort" method. The parameters that are used in this method are explained below.  

 

Expression : DATE>'03/07/2019' and DATE<'3/18/2019'.

Sort ColumnName:  Optional (DATE).

Order: Optional( Asc and Desc)   . 

 

 

 

 Regards,

Swathi Muppalla    

Close