How to apply filter on a data table

  • 74 Views
  • Last Post 2 weeks ago
pankaj.yadav@technobraingroup.com posted this 3 weeks ago

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.intellibot@gmail.com posted this 2 weeks ago

 

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