Hi I excel data with 20 rows of data …i want apply filter in C column data and do some manipulation on column c and unfilter the column c
here in UiPath i see filter data table activity either keep or remove the rows …is there any way that i should not loose the data
Hi @T_Y_Raju
Instead of using the workbook activities, use the excel activities.
→ Use the Filter activity to fiter the rows on ColumnC.
→ You can do manipulations on that data.
→ After that use the Same Filter activity and select the Clear existing filter option. It will unfilter the data.
Check the below image for your understanding,
Hope it helps!!
iam using excel activities only but the classic one
Filter will only hide the values
but if you need to manipulate better to read to datatable do your manipulations and then write back
cheers
Hi @T_Y_Raju
Use filter data table activity and write the filter data in other sheet do your manipulations there as the Unfiltered data will be present in sheet1.
Thanks!!
here the problem is when i write the data back sheet 1 in main sheet …how sheet1 is able to identify the row of the main data where it was earlier in that main sheet row