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.