Check value in another excel

Help Studio
1

Hi,
I have two excel.
in first excel i have id–id1
and in the second excel which is the master excel id–id2 value in excel.
-need to check the whether id1 is available in id2 or not
can anyone help me …

1 Like
2

@vaishaliR

Check below post
Tutorial : How to check a string is present in Excel Sheet || Part - 1
Tutorial : Check value exists in Excel Sheet using UiPath (Part-3) | Without using ForEach Loop/FilterDatatable - #2 by system

Hope this helps you

Thanks

1 Like
3

hey @vaishaliR

this video will solver your doubt: Adding Specific Columns From One Data Table To Other - YouTube

1 Like
4

can you share me the if condition without using for each row part

1 Like
5

@vaishaliR

DT.AsEnumerable().Any(Function(x) x("ColumnName").ToString.ToUpper = Your Value)

If you are using this then you have to add the assembly reference, which i explained how to do

Mark as solution if this helps

Thanks

1 Like
6

@vaishaliR

  1. Read both the excel and store in data tables
  2. Loop through the data table within the other data table and if condition as

row1(“column name”).tostring.Contains(row2(“column name”).tostring)

Hope this will help you

Best Regards,
Vrushali

1 Like
7

Hi,
Thanks for the help…

1 Like
8

Thanks for sharing …

9

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.