Rebuild a data table

Help Studio
, , , , , , ,
1

Hello guys! Basically, I have a workflow, where I take some data from a website and need to upload it to a SQL table, but the data that I take out of the webpage is a mess and needs to be structured.

The data looks like this:

image
image712×611 15.3 KB

The problem is, that Column “Data” values should be the column headers, not values of rows, and Data1 column values should be rows of the headers. How can I do that, so I would get the result needed?

(The data in the webpage looks like this:)

image
image310×504 12.5 KB

NOTE: The values of Data column can be different for other pages, for example - there might be other columns added to the ones that are in the photo or some may not be there

2

Hi @Povilas_Jonikas

Here You can extract as shown in the above image and you can convert the datatable into dictionary and get the values by using keys

Cheers!

1 Like
3

Thanks for the quick response @Dinesh_Guptil, but I actually have no clue about anything when it comes to dictionaries and working with them, because I never have worked with them. Is there any other way?

4

@Povilas_Jonikas
Dont Worry will help you with the syntax.

1 Like
5

Ok, so I made a dictionary out of the data table that I get. Whats next, how can I start making a fresh data table with specific column names and theyr values?

6

@Povilas_Jonikas

After Creating Dictionary variable

Dict = DT.AsEnumerable.ToDictionary(Of string,object)(Function(r) r(Column1).tostring,Function(a) a(column 2).tostring)

Dict(“Rida”).tostring gives the value as 267000 KM

1 Like
7

Ok, thanks :slight_smile: Will try and let you know how it turns out

8

@Povilas_Jonikas Okay
Cheers!