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 in RPA by Vishwanth
• 150 points
109 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
336 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
3,238 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
4,766 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 21, 2018 in RPA by Atul
• 5,530 points
290 views
0 votes
1 answer

Writing multiple column in excel UiPath

You can read the entire Excel sheet ...READ MORE

answered May 9, 2018 in RPA by wrecker
• 3,110 points
2,013 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
599 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
507 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
1,261 views
0 votes
3 answers

Any open source tools for RPA ?

Yes, here is the Free RPA tool ...READ MORE

answered Oct 24, 2018 in RPA by Karthiksiddhu
• 240 points
395 views