How can add the Data Scarping Row Values

Hi,
I want to add the all rows value in a web page. So, By using the Data Scraping I collect the Rows Value and store in [ExtractDataTable]

Can you plz anyone give me a suggestion methods for adding the DataScrpe Values?

Hi @Rajiduraikannu_Santhosh_G

This will be one of the way to achieve this.

image

Code:
SumOfValueInDataTable.xaml (6.1 KB)

Hope this will help you. Thank you.

@Rajiduraikannu_Santhosh_G

In the above post I converted the Price value to Double since in the Data Table the price value is stored as string. If it’s not string, no need to convert.

Thank you.

Thnk You so much @Jobin_Joy . Its wrking

1 Like

Thanks for confirming.

Hi @Jobin_Joy ,
Can you plz resend the previous method because Some time the values chnges its occurs error. So, can resend the first method

Can you please give some more information? It’s not clear.


I got this error?. I set the crt Columnname[TendDrill] but the error was occur

Hi @Rajiduraikannu_Santhosh_G

It should like this,

ExtractDataTable.AsEnumerable.Sum(Function(x) Convert.ToDouble(x(“TrendDrill”).ToString.Trim) ).ToString


I got this error @Jobin_Joy

Can you share your sample flow here?

Note: Make sure the Data Table is not empty and TrendDrill Column values are present in it.

Thank you.


This is my wrkflow scrape the data stored in ExtractDataTable variable [DataTable<<VariableType]
DataTabla have the values and the Column Name also TrendDrill

@Rajiduraikannu_Santhosh_G

Can you please that sample workflow here?

how can i insert the ExtractDataTable Variable in Build Data Table

Hi @Jobin_Joy,
Can u plz rply me

@Rajiduraikannu_Santhosh_G

If you facing AsEnumerable is not member of System.Data.Datatable then check below post

For Older versions you need to follow as above, Newer versions it is not an issue

Hope this will help you

Thanks

But I using the new version 2021.10.4

@Rajiduraikannu_Santhosh_G

Is the project is also the same new version developed?

But in later versions I didn’t see any issues

Thanks

Kindly work on the latest version. You won’t face any such issues as mentioned by @Srini84

Thank you.

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