How to copy Some columns of data to another excel sheet using uipath

[sandhyareddy (Kalyani)]

In the provided excel screenshot it contains asp data. I need to copy only asp data to another excel sheet using iterations.

[Rounak_Kumar1 (Rounak Kumar)]

Hey,
you can use filter data table Activity
you can follow this

thanks

[Shikhar_Tandon]

Hi @sandhyareddy,

In case you want to copy a single column from a datatable you can do something like

Assign left - DT2 (new datatable)
Assign right - DT1.defaultview.totable(False,“Column Name”)

Thanks

[sandhyareddy (Kalyani)]

@Rounak_Kumar1 By using for each loop means how can i do that.

[sandhyareddy (Kalyani)]

@Shikhar_Tandon in the provided excel there are multiple ASP data’s in all those i need to copy only Capgemini ASP data to another sheet.

[Rounak_Kumar1 (Rounak Kumar)]

Hey,
There is no need to use for each row activity
you can follow this workflow which i attached
Dummy.xlsx (9.6 KB)
Sample2.xaml (8.0 KB)
Thanks
Rounak

[ushu (Usha kiranmai)]

Hello @sandhyareddy Please try the attached workflow

Example.zip (10.8 KB)

Input

Output

[sandhyareddy (Kalyani)]

@ushu Thank you it worked for me.