How to search the input date and get the corresponding data in the columns

Help Automation Ops
,
1

How to search the input date and get the corresponding data in the columns. If the date is input, there are 3 columns like date,data1,data2.
if the input is march-2023 then it should search for narch-2023 then the data should get from the corresponding columns.

2

Hi Anjani Priya,

Assuming that the columns you are referring to, are in an Excel file. You can create a data table using read range activity.
Then leverage the Filter Data table activity where you can set the filter wizard for setting up the filters we need. Added in this comment is the link to filter data table activity. Hope this suggestion helps you find the solution.

Happy Automating.!

3

Hi @anjani_priya

sample1 1.xaml (69.5 KB)

Regards

4

EXCEL FILE (1).xlsx (21.8 KB)

5

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.