Filter data on basis of one column and write to other excel

[som17 (Som)]

Hi all,
I have an excel in which colum “p” contains true false vales.I want the BOT to filter out rows containing “False” values and on the basis of that write all the data present in A-J in other excel sheet.Test.xlsx (10.9 KB)

[Pratik_Wavhal]

Hi @som17

Below is the workflow for the same :-
som17.xaml (19.8 KB)

Check the above workflow once

Mark as solution and like it if this helps you

Happy Automation

Best Regards
Er Pratik Wavhal

[som17 (Som)]

thanks for the help pratik…
I want to delete the data of last 2 column of that test excel and write the remaining into new csv.
Can u please help in this as well.

[som17 (Som)]

Hi Pratik…can u pls reply

[Pratik_Wavhal]

Hi @som17

Actually i am getting some error in my UiPath and Excel is also not working bcz of some reason so i was not able to do anything.

Now i have made the workflow for your query. Below is the same :-
UpdatedDelColsom17.xaml (24.3 KB)
Test.xlsx (11.1 KB)

Mark as solution and like it if this helps you

Happy Automation

Best Regards
Er Pratik Wavhal

[som17 (Som)]

i did the same what u suggested but when i used write csv activity and passed this dt…BOT still wrote the the previous datatable data and not teh data that is left after deleting these excel columns

[Pratik_Wavhal]

Hi @som17

I am getting the correct output. Check the below workflow which creates the CSV file after deleting the last 2 columns from Excel

UpdatedDelColsom17.xaml (25.2 KB)

Mark as solution and like it if this helps you

Happy Automation

Best Regards
Er Pratik Wavhal