I have one Excel file in which there are many duns data,I want to extract one duns data.in the Excel file they have used some formatting like they have colour some cells.tobextract the data for one duns number I have used filter datatable activity it filter the data but it didn’t delete the unfiltered data.how to resolve this issue?
TIA
Hi @Cuberoot ,
Have you check filter input/output data, keep and remove column?
You can share file and your filter activity?
regards,
1 Like
Hi @Cuberoot
Do you want to filter with the cell color or filter with the specific data.
Elaborate your answer more then only we understand and we will give the better solution for your query.
Can you do it in the same sheet?
can you clear it, I don’t understand
I want to filter the data in the same file.
that output I used your file
report.xlsx (15.1 KB)
I don’t quite understand what you mean, or can you share your expect output?
I will edit for you
After filtering and recording the output, do the other data still need to be kept?
if like your output, i have another solution
we will copy the file to keep the format
read from A6, then get data, filter and record, otherwise the data to be filtered will be blank
what do you see?
but in the file their is date… that is the issue.I dont want other data
Yes, I see
we can get data from A-L columns
read then filter get only column A-L
is it possible to remove the unwanted data in the same file?
Yes, my idea is we get file to get temple, then filter and write back
what about date column?
I think you don’t understand my way
wait me a few minutes, I need test it then send to you
Hi @Cuberoot ,
My code
linq.xaml (12.4 KB)
my input
report.xlsx (15.1 KB)
my tempete
temple.xlsx (14.5 KB)
my output
report.xlsx (14.2 KB)
you can see and try it
Anil_G
Nguyen_Van_Luong1
Palaniyappan
Anelisa_Bolosha1
mpraveen1902
Yoichi
sathya_auto
Shiva_Nikhil
supermanPunch
A_Learner