Filter column name and copy in new Excel sheet

0 votes

Hi Team,

I’m facing an issue while filtering the column of one excel sheet with other.

image

Consider: BlueWater- I’m expecting the result in another data table as below.
image

and similarly for other customer.
image
and if there is no matching customer name from sheet1 then just display the data availabel in sheet1
image

Mar 24, 2020 in RPA by Vishwanth
• 150 points
2,848 views
So basically, you are facing trouble with displaying the filtered data from the two sheets? Is that your query?

Are you using Filter dataTable Activity or Select query to filter dataTable?

Yes.I'm facing the issue with displaying the filtered data. I'm using Filter Data tabe.
You could configure the output data table in the filter wizard I guess.
I have tried filter wizard, but to achieve it dynamically. As it has to compare the name from one sheet with other and it it finds then paste in th new sheet

In that case, may be you should use select query for filtering out the data and use assign activity along with it.

No answer to this question. Be the first to respond.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.

Related Questions In RPA

0 votes
0 answers

HOW to extract a column data and save it in the new sheet using UIPATH

Sep 12, 2019 in RPA by anonymous
• 120 points
2,255 views
0 votes
2 answers

change a specific column of an excel sheet in UiPath

1. First of all , you need ...READ MORE

answered May 16, 2019 in RPA by Venkat
• 320 points
5,792 views
0 votes
4 answers

How to find the sum of 2 columns of an excel and display it in a 3rd column using UIPATH?

These are the steps to add two ...READ MORE

answered Aug 2, 2019 in RPA by Shivi Singhal
14,651 views
0 votes
1 answer

Changing a specific column of an excel sheet in UiPath

You can use a For each row ...READ MORE

answered Jun 22, 2018 in RPA by ffdfd
• 5,550 points
1,073 views
0 votes
0 answers

How to merge multiple excel column value in one excel? The column name are same but are in different order.

How to merge multiple excel column value ...READ MORE

Sep 28, 2020 in RPA by Tej
• 150 points
1,757 views
0 votes
1 answer

Uipath(RPA) : read data from the PDF file and write to Excel file

If you want to use UiPath and ...READ MORE

answered Oct 17, 2022 in Others by narikkadan
• 63,720 points
2,082 views
0 votes
1 answer

Robot Manager in UiPath

the robot.exe file is located in: C:\Users\USER_ACCOUNT\AppData\Local\UiPath\app-17.1.6523\Ui-Robot.exe Hope it ...READ MORE

answered Apr 17, 2018 in RPA by wrecker
• 3,110 points
1,824 views
0 votes
1 answer

Automation in Uipath

you can use the Database package for connecting  ...READ MORE

answered Apr 17, 2018 in RPA by wrecker
• 3,110 points
1,564 views
0 votes
1 answer

UiPath vs Workfusion

in WorkFusion, you can create a script ...READ MORE

answered Apr 17, 2018 in RPA by wrecker
• 3,110 points
2,636 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP