Need to check if rows exist or not in Data tables

Help Studio
, ,
1

In my first transaction item:

some data get and feed into my already existed empty excel

like:
image

In my second translation item some data fetched and feed into existed DB (have to append) before feed I have to check each row of (Operator name+E212+E214+Global Title) if not exist then add row , if exist then do nothing

My second transcation data like:

image

Need out put like:

image

Thanks
Shaik

2

Use Append Range activity from UiPath

3

But I have to check each column (Operator Name+TADIG+E212+E214+Global Title) if exist do nothing , if not then add row

4

First assign excel Table in DataTable.
Use For Each Row and pass conditions is empty
and if yes then Add Row.

Hope this will help…

You can also refer

5

@shaik.muktharvalli1

dt2.asenumerable.except(dt1.asenumerable,system.data.datarowcomparer.default).copytodatatable

Use the above expression and append that to first datatable

6

Hi,

Input:-

image
image721×264 10.8 KB

image
image720×303 12 KB

Output:-
image

Xaml File:-
Main.xaml (13.7 KB)

If this works for you, please mark it as a solution, so other can refer the same… :slight_smile:

Thanks

7

not only Operator column but I have to check all columns

1 Like
8

Hi,

Updated xaml file:-
Main.xaml (13.7 KB)

Thanks

1 Like
9

If my data table all columns in Object instead of string

Please give expression

1 Like
10

Hi,

Provided xaml code will work for object as well as string.

Thanks

11

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