Filter column in excel

I want to filter column E

condition :
In sheet1 date< 30/1/2021 and sheet2 date < 3/4/2021
then write data in same sheet (yellow highlight)data.xlsx (9.6 KB)


Guide me about it.

Hi @fairymemay

I have one doubt here. Have to delete all the values from excel and write only the condition matched values in both sheets, or should write in separate sheet?


1 Like

Hey @fairymemay,

So use filter data table activity in both the sheets and then finally use merge data table to combine them.
If you are facing any issue in it. Do let me know I will do it for you.

Convert into the date type and then filter the using filter data table activity with appropriate date format.

@vignesh.ks write in separate sheet.

Remark : 30/1/2021 and 3/4/2021 are variable as string.

Guide​ me​ about​ it​ please.

Hi @fairymemay

Please find the attached xaml file for your reference.

Filter_DT_Date.xaml (14.5 KB)

Feel free to reach us at any time if you have doubts. Thanks.

Happy Automation

1 Like

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