Copy selected columns from one excel to another based on partial search word

[Susana (Susana González Cacheiro)]

Hello @Learning,

Which is the problem that you are getting? Have you tried to use Linq querys on the datatable?

There are a lot of examples on the forum:

Check record in web page

Hi all, I have a case, I have read row in excel then query in webpage and if it exist will update it otherwise I have to display message ’ The row doesn’t exist’… I have complete the reading from excel and query, how can I check if the record is there or not… thanks in advanced and your help will be appreciated…

Use of contains key word in select statement

i have two data table and datetime as a datetype need to check and compare the values of Datetime i thought of converting the value of the datetime column to string and use = and which am not able to perform. any suggestions for the same…?? how to use contains key word in select statement in UIpath…?? Thank you

Need to filter a column in excel that starts with same first 2 numbers

Hi All, I have an excel file and I want to apply a filter to a column. Column name is sequence Id that having a 10 digit sequence id. I need to find the sequence ids which starts with 45xxxxxxxx. Can anyone pls help me? Thanks Jose

Pulling data from one sheet to filter another sheet

I have a table in an excel sheet where Column 2 contains the following codes : 001 002 003 004 005 I have a table in another excel workbook (the master workbook) in which Column 2 contains codes from 001 to 500 (codes are repeated). I need to pull all the codes from Step 1 and use them to filter Column 2 of the master workbook. Once I do this, I need to write that filtered table into a new sheet in the master workbook itself. Note : Codes in Step 1 are dynamic and may vary between 001 …

Let’s us know your progress

Thanks and best regards,
Susana