Hello there ! I have DataTable problem help please

Help
1

todayToron is first DataTable Type

%EC%98%A4%EB%8A%98%EC%84%A0%EC%88%98

toronHitter is second DataTable Type
%ED%83%80%EC%9E%90%EC%A0%84%EC%B2%B4%20%EC%84%A0%EC%88%98

I want to output the fullName and all grades of the players included in todayToron to excel or writer line. Please help me.

The biggest problem is the name of “todayToron” and the fullname of “toronHitter” are different.

1 Like
2

For each row in Toron,
for each row2 in Hitter, do
row2(“player”).toString().Contains(row(0).toString() // “Davis” or “Drury”) => True or False
If True, get the Row and process it
Else Continue

2 Likes
3

Hi Buddy @Hyun

Welcome to UiPath community buddy
Its resolved
here you go buddy with the xaml
Run the xaml buddy you can see the results in write line buddy
comparing.zip (23.7 KB)

Hope this would help you
Cheers

1 Like
4

You have to use nested For each row to achieve this, but if the today toron has some name which will be there in more than 1 in toronHitter table everything will match.
you can go for a check innerrow.item(“Player”).tostring.containsOf(row.item(“TodayToron”)).

2 Likes
5

Thanks for help it is helpful of me : )

6

Thanks for answer , but I do not know what activities to put in the red square. And what should I write?

Inked%EC%BA%A1%EC%B2%98_LI

7

did that work buddy @Hyun

8

Thanks, but the console output is not what I want

9

may i know what was the output you were expecting buddy @Hyun

10

We have confirmed that the full name and the overall score are good output.
But I need the full name and the overall score of nine players in “todayTron”.

Your process output is only six.

1 Like
11

Buddy i did’t have the full data of yours…so what i did is u just made a scree scrapping of your attached image in tha question and made a excel…all these were done in backend before sending you the xaml…that excel has only the data of your attached image…and your image has only six…matvhi values…thats why buddy
You can pass your data and check buddy with read range activity…
Cheers @Hyun

12

Hello @Hyun as pointed out by @Palaniyappan data for Drury,Grease and Ribsl is
missing in toronHitter data… as a result only 6 matches were found

13

It is my fault
The data table has been modified.
so it problem is Resolved!. Thank you so much buddy :smile:

1 Like
14

Thats great…

If this gets resolved kindly make a solution that could help others looking for ideas under your topic buddy
Cheers @Hyun

1 Like