How can add the Data Scarping Row Values

[Rajiduraikannu_Santhosh_G (Santhosh)]

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?

[Jobin_Joy]

Hi @Rajiduraikannu_Santhosh_G

This will be one of the way to achieve this.

Code:
SumOfValueInDataTable.xaml (6.1 KB)

Hope this will help you. Thank you.

[Jobin_Joy]

@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.

[Rajiduraikannu_Santhosh_G (Santhosh)]

Thnk You so much @Jobin_Joy . Its wrking

[Jobin_Joy]

Thanks for confirming.

[Rajiduraikannu_Santhosh_G (Santhosh)]

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

[Jobin_Joy]

@Rajiduraikannu_Santhosh_G

previous method

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

[Rajiduraikannu_Santhosh_G (Santhosh)]

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

[Jobin_Joy]

Hi @Rajiduraikannu_Santhosh_G

It should like this,

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

[Rajiduraikannu_Santhosh_G (Santhosh)]

I got this error @Jobin_Joy

[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.

[Rajiduraikannu_Santhosh_G (Santhosh)]

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

[Jobin_Joy]

@Jobin_Joy

Can you share your sample flow here?

@Rajiduraikannu_Santhosh_G

Can you please that sample workflow here?

[Rajiduraikannu_Santhosh_G (Santhosh)]

how can i insert the ExtractDataTable Variable in Build Data Table

[Rajiduraikannu_Santhosh_G (Santhosh)]

Hi @Jobin_Joy,
Can u plz rply me

[Srini84 (Srinivas Kadamati)]

@Rajiduraikannu_Santhosh_G

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

AsEnumerable is not a member of 'System.Data.Datatable'

When trying to use the AsEnumerable() method on a data table, i receive a error stating that AsEnumerable is not a member of ‘System.Data.Datatable’. I’ve seen someone else with this problem and their solution was to use temporary data table activities in their project to load in the System.Data.DataSetExtension library. However this has not worked for me. Any help would be greatly appreciated. Thank you.

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

Hope this will help you

Thanks

[Rajiduraikannu_Santhosh_G (Santhosh)]

But I using the new version 2021.10.4

[Srini84 (Srinivas Kadamati)]

@Rajiduraikannu_Santhosh_G

Is the project is also the same new version developed?

But in later versions I didn’t see any issues

Thanks

[Jobin_Joy]

@Rajiduraikannu_Santhosh_G

Can u plz rply me

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

Thank you.