Getting specific data from tabledata

Help Activities
1

So this is what I must do:

  1. Uses Input Dialog for typing in a name of a football player from the top 50 goalscorer list of men’s Uefa Champions League and saving it into a string variable.
  2. opens a browser session in the following url "https://en.wikipedia.org/wiki/List_of_UEFA_Champions_League_top_scorers" and extracts the amount of goals the given player has scored in the competition

So, I have done Table Extraction and have datatable. But then I dont get to use for example each row, because it says columns are not declared. I need to do program that asks me player name with input dialog, but how I get the goals from there? I have hit my head in the wall for hours with this pls help!!

Forum Engagement Daily Reports
2

Hi @Kalle77

Write the extracted to a excel file and share it with us, then we can use the LINQ Expression to compare the Input dialog box input with the Excel data then we can get the Amount of goals of the player easily.

Hope you understand!!

3

@Kalle77

Please share the excel file so that we find out how to get the goals from that datatable

4

will work as we cross-checked here:

grafik
grafik642×543 158 KB

So the basic flow is about:

  • Input Dialog - ask for the name
  • Extract DataTable
  • Filter DataTable
  • use the amount of goals from the filter result row

Once the happy path is implemented then we suggest to do some modifications like:

  • filter result validation
  • offer a list of known players to the input dialog
    *…
1 Like
5

Thanks, this helped! But it says in filter datatable when I put to Column = Goals

It says Column type is not supported?

6

Uipathfoorumille
Uipathfoorumille1386×960 60.3 KB

So its like this but it says column not supported. I have player variable in input dialog to be the value that is entered by user.

7

I don’t use Excel, only datatable in UiPath.

8

@Kalle77

I want excel data for reference purpose only write the datatable data to excel

9

Goals is the Columnname so it is a string you will surround it with "

grafik
grafik793×397 51.9 KB

do not missout also to configure the Filtered DataTable setting

10

ExtractDatatabletoExcel
ExtractDatatabletoExcel887×960 34.2 KB

I tried to extract it for excel but for some reason this doesn’t work, so I cant even do that.

11

Thanks, I did not understand it needs “” !
Now I think this is almost done, but it just prints me “Data table” ? I can’t understand…

datatable1
datatable11367×960 52.9 KB

12

Datatable2
Datatable2897×960 43.5 KB

13

use the immediate panel and inspect the datatable there:
Understanding the 6 Debugging Panels of UiPath in the easiest way possible! - News / Tutorials - UiPath Community Forum

14

There is no answer for this. It just prints " Datatable" and it looks totally right.

15

Uipathfoorumiin
Uipathfoorumiin870×960 36.6 KB

So this is where i’m at. I tried to just take the datatable without filtering with message box to test, and it gives there already “Data table” in the msg box. Why it’s not printing the data table?

16

dataTable is a so called complex datatype and has not an out-of-the box method, which dumps out the content / values as text.

Therefore we mention to do inspections / tracing of part results with immediate panel

If mandatory is needed, that you need a text representation of the datatable then have a look at this activity:

17

I did look into it, but I don’t still understand.

18

“To String” is not working in variable, so how I can get my datatable in the situation that I can print the text of it?

19

DataTableVar.ToString() will output the Class Name but not a string with the datatable content / column values

20

we mentioned:

and it will return a string representing the datatable and its content