Extract attribute as column from HTML table

[tejastandel007 (Tejas Tandel)]

Hello,

I am trying to extract data from each column using data scraping but there is one column name ‘PDF needed’ with value as checkmark symbol. So, while extracting into data table the column does not show any value as it is a checkmark symbol.

My question is, is there any different way getting the values of such column? How can it be done with using attribute?

Thanks in advance.

[Nithinkrishna]

Hey @tejastandel007

I hope you are using the Data Table Scraping method for this.

You can just tweak the ExtractMetadata of the Extract Structured Data activity which should do the job.

You can please post your table screenshot & metadata for more help on it.

Thanks
#nK

[tejastandel007 (Tejas Tandel)]

Hey @Nithinkrishna

Yes, am using the data scraping activity. I am getting confused while tweaking the metadata.

The metadata:

The table screenshot:

As you can see the fourth column has value as symbol and I need to get any identifier for that.

Hope this helps.

[ppr (Peter Preuss)]

have a look here:

[HowTo] Data Scraping - Advanced Configuration - Text Field, Image Source, Url, CSS Classname, Hover text

This HowTo introduces on how Data scraping can be configured to retrieve also on non standard information from a web table. After indicating the different data columns with the wizard the extract data definition was post edited and changed to the relevant attributes e.g. value (Text field), src ( Image Source), class (CSS Class Name), tite (Hover Text), href (Url). Introduction Following web table is to use for data scraping and also the non text information should be retrieved. [grafik] We…

do a check on the green symbol and analyse its details on what it is. Icon, class…

[Nithinkrishna]

Hey @tejastandel007

Could you please show us the selector for the check icon please ?

Thanks
#nK

[Shikhar_Tandon]

Hi @tejastandel007,

See if the above link if it can help you

[HowTo] Data Scraping - Advanced Configuration - Text Field, Image Source, Url, CSS Classname, Hover text

This HowTo introduces on how Data scraping can be configured to retrieve also on non standard information from a web table. After indicating the different data columns with the wizard the extract data definition was post edited and changed to the relevant attributes e.g. value (Text field), src ( Image Source), class (CSS Class Name), tite (Hover Text), href (Url). Introduction Following web table is to use for data scraping and also the non text information should be retrieved. [grafik] We…

Thanks

[tejastandel007 (Tejas Tandel)]

Here you go!
webctrl aaname=’ ’ tableCol=‘4’ tableRow=‘47’ tag=‘DIV’ class=‘list-cell-content’

In DIV tag there is one more DIV and SPAN tag but while selecting that it shows invalid UI node.

[Nithinkrishna]

Hey @tejastandel007

Yes I think we need to see that selector inside div for other div and span.

Could you please try indicating it by changing the UiFramework or try making it as target from visual tree…

Thanks
#nK

[tejastandel007 (Tejas Tandel)]

Thanks for sharing!

This post has helped me and my issue is resolved.

[tejastandel007 (Tejas Tandel)]

Thanks for the reply. The issue has been resolved

[Nithinkrishna]

Cool @tejastandel007