Select Method not working

[Rakesh_Tiwari]

Hi all,

just a small query, i am trying to sort the Data table based on condition and write in excel but not able to achieve it.

what i have done is
used select method to filter. refer img below

then used for each loop, img refer below

but i am getting this error,img refer below

i am using flipkart app and product as TV and scrapping the data(Name, price and Rating) and i want that data should sort based on Price whose value is more than 20,000 and want to calculate average product price.
thanks in advance

[AshwinS2 (Ashwin S)]

Hi @Rakesh_Tiwari

use ExtractDatatable.Select("[Price]>=‘20000’). CopyToDatatable()

Thanks
Ashwin.S

[Rakesh_Tiwari]

Hi,

Not working, same error is coming.

what could be the reason of this?

[Rakesh_Tiwari]

Hi @sundalpathy

i can’t see the file.

[Srini84 (Srinivas)]

@Rakesh_Tiwari

Check below

Hope this helps you

Thanks

[Rakesh_Tiwari]

Hi,

Thanks for replying.

i think there is no issue with logic, issue with datatable,

when i put o/p dt after datascraping and used msgbox, but it doesn’t show me anything.

[Rakesh_Tiwari]

used writeline and got this result.

.

it doesn’t return count.

[AshwinS2 (Ashwin S)]

Hi @Rakesh_Tiwari

U mean to say DataScrapping issue

Thanks
Ashwin.S

[Rakesh_Tiwari]

yes, because it doesn’t return the count of rows.

[Rakesh_Tiwari]

that issue is fixed like it is writing the data in excel, but geeting this error.

kindly provide the solution for it.

[Rakesh_Tiwari]

hi,

why it is throwing this error?