Appending the rows of an excel document to another excel document, given that a condition is met

[Hisuhong]

Hello! I am new to UiPath and I am currently trying to filter out supplier contact information data in an excel sheet by separating the rows with “Yes” in the 11th column from the rows without it. I am unsure about how to add the rows that meet and don’t meet the conditions into their respective excel docs (“validated Supplier Contact Info.xlsx” and “Invalid Supplier Contact Info.xlsx”)

This is what I tried to do but it does not work.
Also, I tried SupplierContact.Rows.IndexOf(rowIndex).ToString but it returns an error.

Sorry for the long post, and I would appreciate the help

[HareeshMR (Hareesh Madasi)]

Why don’t you use the Filter Data table activity which will give you the new data table that contains the values YES so that you can write the data table to any excel @Hisuhong

[Hisuhong]

Ohhhh I forgot that exists! Thank you I’ll try it out

[Hisuhong]

@HareeshMR Hi so this is what I tried out

It did not give me an error but it did not write out the values to the new Excel doc.
(Note: DT_Valid is the output data table from the filter)

[HareeshMR (Hareesh Madasi)]

You don’t need output data table activity, you can write the output data table from filter data table activity. Can you check writing the value to the excel using write range activity instead of append range?

[Hisuhong]

Ohh! Yes that worked! Thank you so much! Is there a way I can transfer the headers from the old document to the new one?

[Hisuhong]

Nevermind I think I got it. Anyways, thank you very much @HareeshMR