Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I am working with data from an HTML table on a website.
Is there a way to hide all the HTML code generated from Web Page datasource?
It is very boring scrolling down all this rows each time to edit in Advanced Editor.
Regards
#"Extracted Table From Html" = Html.Table(Source, {{"Column1", "TABLE > * > TR > TD[colspan=""2""]:not([rowspan]):nth-child(1):nth-last-child(5), TABLE > * > TR > TD[colspan=""14""]:not([rowspan]):nth-child(1):nth-last-child(1), TABLE > * > TR > TD:not([colspan]):not([rowspan]):nth-child(1):nth-last-child(14), TABLE > * > TR > TD[colspan=""9""]:not([rowspan]):nth-child(1):nth-last-child(3), TABLE > * > TR > TD:not([colspan]):not([rowspan]):nth-child(1):nth-last-child(5), TABLE > * > TR > TD[colspan=""10""]:not([rowspan]):nth-child(1):nth-last-child(5), TABLE > * > TR > TD[colspan=""12""]:not([rowspan]):nth-child(1):nth-last-child(2), TABLE > * > TR > TD[colspan=""10""]:not([rowspan]):nth-child(1):nth-last-child(3), TABLE > * > TR > TD:not([colspan]):not([rowspan]):nth-child(1):nth-last-child(10), TABLE > * > TR > TD[colspan=""13""]:not([rowspan]):nth-child(1):nth-last-child(1), TABLE > * > TR > TD[colspan=""2""]:
Solved! Go to Solution.
@gpiero - Perhaps try separating that step into it's own function. Then it won't clutter up your main query.
it is very likely you meant the solution below.
The first quey TbItemOverview contains only the statement to import data from Web page
let
Source = TbItemOverview,
#"Changed Type" = Table.TransformColumnTypes(#"Extracted Table From Html",{{"Column1", type text}, {"Column2", type text}, {"Column3", type text}, {"Column4", type text}, {"Column5", type text}, {"Column6", type text}, {"Column7", type text}, {"Column8", type text}, {"Column9", type text}, {"Column10", type text}, {"Column11", type text}, {"Column12", type text}, {"Column13", type text}, {"Column14", type text}}),
Then in new query I should recreate the proper command to model data.
Thanks for the right direction.
Regards
Hi @gpiero
There is no way to hide all the HTML code generated from Web Page datasource.
However, I would copy the M code in Notepad++ editor and not use the word wrap, this will display it in one line.
word wrap button on Notepad++
Once my edit is done, I would copy and paste it back.
Hope it resolves your issue? Did I answer your question? Mark my post as a solution! Appreciate your Kudos, Press the thumbs up button!! Linkedin Profile |
Hi @pranit828 ,
many thanks for your advice. At moment I do not think it is the best solution for me. Working in this way means, if I uderstood well, copy & paste n times between Notepad ++ and Advanced Editor increasing mistakes and issues.
Thanks again
Regards
@gpiero - Perhaps try separating that step into it's own function. Then it won't clutter up your main query.
it is very likely you meant the solution below.
The first quey TbItemOverview contains only the statement to import data from Web page
let
Source = TbItemOverview,
#"Changed Type" = Table.TransformColumnTypes(#"Extracted Table From Html",{{"Column1", type text}, {"Column2", type text}, {"Column3", type text}, {"Column4", type text}, {"Column5", type text}, {"Column6", type text}, {"Column7", type text}, {"Column8", type text}, {"Column9", type text}, {"Column10", type text}, {"Column11", type text}, {"Column12", type text}, {"Column13", type text}, {"Column14", type text}}),
Then in new query I should recreate the proper command to model data.
Thanks for the right direction.
Regards
@gpiero - Yes, you got it, sorry for not being more specific!
Does it mean I could create a sort of subroutine or a separate query only for import data?
And then open a new quey for modeling data and so on?
Is there some example just to "turn on the lamp in my mind"?
Thanks in advance
Regards
I mean below the dimension of my issue!!!!!!
I truncated with Notepadd ++ less than 20k characthers. It was 36k!!!!
let
Source = File.Contents("C:\Users\giamp\OneDrive\TOL Data Cloud\Analisi Fattacci\StatementOverview.htm"),
#"Extracted Table From Html" = Html.Table(Source, {{"Column1", "TABLE > * > TR > TD[colspan=""2""]:not([rowspan]):nth-child(1):nth-last-child(5), TABLE > * > TR > TD[colspan=""14""]:not([rowspan]):nth-child(1):nth-last-child(1), TABLE > * > TR > TD:not([colspan]):not([rowspan]):nth-child(1):nth-last-child(14), TABLE > * > TR > TD[colspan=""9""]:not([rowspan]):nth-child(1):nth-last-child(3), TABLE > * > TR > TD:not([colspan]):not([rowspan]):nth-child(1):nth-last-child(5), TABLE > * > TR > TD[colspan=""10""]:not([rowspan]):nth-child(1):nth-last-child(5), TABLE > * > TR > TD[colspan=""12""]:not([rowspan]):nth-child(1):nth-last-child(2), TABLE > * > TR > TD[colspan=""10""]:not([rowspan]):nth-child(1):nth-last-child(3), TABLE > * > TR > TD:not([colspan]):not([rowspan]):nth-child(1):nth-last-child(10), TABLE > * > TR > TD[colspan=""13""]:not([rowspan]):nth-child(1):nth-last-child(1), TABLE > * > TR > TD[colspan=""2""]:not([rowspan]):nth-child(1):nth-last-child(6)"}, {"Column2", "TABLE > * > TR > TD[colspan=""2""]:not([rowspan]):nth-child(1):nth-last-child(5), TABLE > * > TR > TD[colspan=""14""]:not([rowspan]):nth-child(1):nth-last-child(1), TABLE > * > TR > TD:not([colspan]):not([rowspan]):nth-child(1):nth-last-child(14) + TD:not([colspan]):not([rowspan]):nth-child(2):nth-last-child(13), TABLE > * > TR > TD[colspan=""9""]:not([rowspan]):nth-child(1):nth-last-child(3), TABLE > * > TR > TD:not([colspan]):not([rowspan]):nth-child(1):nth-last-child(5) + TD:not([colspan]):not([rowspan]):nth-child(2):nth-last-child(4), TABLE > * > TR > TD[colspan=""10""]:not([rowspan]):nth-child(1):nth-last-child(5), TABLE > * > TR > TD[colspan=""12""]:not([rowspan]):nth-child(1):nth-last-child(2), TABLE > * > TR > TD[colspan=""10""]:not([rowspan]):nth-child(1):nth-last-child(3), TABLE > * > TR > TD:not([colspan]):not([rowspan]):nth-child(1):nth-last-child(10) + TD:not([colspan]):not([rowspan]):nth-child(2):nth-last-child(9), TABLE > * > TR > TD[colspan=""13""]:not([rowspan]):nth-child(1):nth-last-child(1), TABLE > * > TR > TD[colspan=""2""]:not([rowspan]):nth-child(1):nth-last-child(6)"}, {"Column3", "TABLE > * > TR > TD[colspan=""2""]:not([rowspan]):nth-child(1):nth-last-child(5) + TD[colspan=""5""]:not([rowspan]):nth-child(2):nth-last-child(4), TABLE > * > TR > TD[colspan=""14""]:not([rowspan]):nth-child(1):nth-last-child(1), TABLE > * > TR > TD:not([colspan]):not([rowspan]):nth-child(1):nth-last-child(14) + TD:not([colspan]):not([rowspan]):nth-child(2):nth-last-child(13) + TD:not([colspan]):not([rowspan]):nth-child(3):nth-last-child(12), TABLE > * > TR > TD[colspan=""9""]:not([rowspan]):nth-child(1):nth-last-child(3), TABLE > * > TR > TD:not([colspan]):not([rowspan]):nth-child(1):nth-last-child(5) + TD:not([colspan]):not([rowspan]):nth-child(2):nth-last-child(4) + TD:not([colspan]):not([rowspan]):nth-child(3):nth-last-child(3), TABLE > * > TR > TD[colspan=""10""]:not([rowspan]):nth-child(1):nth-last-child(5), TABLE > * > TR > TD[colspan=""12""]:not([rowspan]):nth-child(1):nth-last-child(2), TABLE > * > TR > TD[colspan=""10""]:not([rowspan]):nth-child(1):nth-last-child(3), TABLE > * > TR > TD:not([colspan]):not([rowspan]):nth-child(1):nth-last-child(10) + TD:not([colspan]):not([rowspan]):nth-child(2):nth-last-child(9) + TD:not([colspan]):not([rowspan]):nth-child(3):nth-last-child(8), TABLE > * > TR > TD[colspan=""13""]:not([rowspan]):nth-child(1):nth-last-child(1), TABLE > * > TR > TD[colspan=""2""]:not([rowspan]):nth-child(1):nth-last-child(5) + TD[colspan=""2""]:not([rowspan]):nth-child(2):nth-last-child(4), TABLE > * > TR > TD[colspan=""2""]:not([rowspan]):nth-child(1):nth-last-child(6) + TD[colspan=""2""]:not([rowspan]):nth-child(2):nth-last-child(5)"}, {"Column4", "TABLE > * > TR > TD[colspan=""2""]:not([rowspan]):nth-child(1):nth-last-child(5) + TD[colspan=""5""]:not([rowspan]):nth-child(2):nth-last-child(4), TABLE > * > TR > TD[colspan=""14""]:not([rowspan]):nth-child(1):nth-last-child(1), TABLE > * > TR > TD:not([colspan]):not([rowspan]):nth-child(1):nth-last-child(14) + TD:not([colspan]):not([rowspan]):nth-child(2):nth-last-child(13) + TD:not([colspan]):not([rowspan]):nth-child(3):nth-last-child(12) + TD:not([colspan]):not([rowspan]):nth-child(4):nth-last-child(11), TABLE > * > TR > TD[colspan=""9""]:not([rowspan]):nth-child(1):nth-last-child(3), TABLE > * > TR > TD:not([colspan]):not([rowspan]):nth-child(1):nth-last-child(5) + TD:not([colspan]):not([rowspan]):nth-child(2):nth-last-child(4) + TD:not([colspan]):not([rowspan]):nth-child(3):nth-last-child(3) + TD[colspan=""10""]:not([rowspan]):nth-child(4):nth-last-child(2), TABLE > * > TR > TD[colspan=""10""]:not([rowspan]):nth-child(1):nth-last-child(5), TABLE > * > TR > TD[colspan=""12""]:not([rowspan]):nth-child(1):nth-last-child(2), TABLE > * > TR > TD[colspan=""10""]:not([rowspan]):nth-child(1):nth-last-child(3), TABLE > * > TR > TD:not([colspan]):not([rowspan]):nth-child(1):nth-last-child(10) + TD:not([colspan]):not([rowspan]):nth-child(2):nth-last-child(9) + TD:not([colspan]):not([rowspan]):nth-child(3):nth-last-child(8) + TD:not([colspan]):not([rowspan]):nth-child(4):nth-last-child(7), TABLE > * > TR > TD[colspan=""13""]:not([rowspan]):nth-child(1):nth-last-child(1), TABLE > * > TR > TD[colspan=""2""]:not([rowspan]):nth-child(1):nth-last-child(5) + TD[colspan=""2""]:not([rowspan]):nth-child(2):nth-last-child(4), TABLE > * > TR > TD[colspan=""2""]:not([rowspan]):nth-child(1):nth-last-child(6) + TD[colspan=""2""]:not([rowspan]):nth-child(2):nth-last-child(5)"}, {"Column5", "TABLE > * > TR > TD[colspan=""2""]:not([rowspan]):nth-child(1):nth-last-child(5) + TD[colspan=""5""]:not([rowspan]):nth-child(2):nth-last-child(4), TABLE > * > TR > TD[colspan=""14""]:not([rowspan]):nth-child(1):nth-last-child(1), TABLE > * > TR > TD:not([colspan]):not([rowspan]):nth-child(1):nth-last-child(14) + TD:not([colspan]):not([rowspan]):nth-child(2):nth-last-child(13) + TD:not([colspan]):not([rowspan]):nth-child(3):nth-last-child(12) + TD:not([colspan]):not([rowspan]):nth-child(4):nth-last-child(11) + TD:not([colspan]):not([rowspan]):nth-child(5):nth-last-child(10), TABLE > * > TR > TD[colspan=""9""]:not([rowspan]):nth-child(1):nth-last-child(3), TABLE > * > TR > TD:not([colspan]):not([rowspan]):nth-child(1):nth-last-child(5) + TD:not([colspan]):not([rowspan]):nth-child(2):nth-last-child(4) + TD:not([colspan]):not([rowspan]):nth-child(3):nth-last-child(3) + TD[colspan=""10""]:not([rowspan]):nth-child(4):nth-last-child(2), TABLE > * > TR > TD[colspan=""10""]:not([rowspan]):nth-child(1):nth-last-child(5), TABLE > * > TR > TD[colspan=""12""]:not([rowspan]):nth-child(1):nth-last-child(2), TABLE > * > TR > TD[colspan=""10""]:not([rowspan]):nth-child(1):nth-last-child(3), TABLE > * > TR > TD:not([colspan]):not([rowspan]):nth-child(1):nth-last-child(10) + TD:not([colspan]):not([rowspan]):nth-child(2):nth-last-child(9) + TD:not([colspan]):not([rowspan]):nth-child(3):nth-last-child(8) + TD:not([colspan]):not([rowspan]):nth-child(4):nth-last-child(7) + TD:not([colspan]):not([rowspan]):nth-child(5):nth-last-child(6), TABLE > * > TR > TD[colspan=""13""]:not([rowspan]):nth-child(1):nth-last-child(1), TABLE > * > TR > TD[colspan=""2""]:not([rowspan]):nth-child(1):nth-last-child(5) + TD[colspan=""2""]:not([rowspan]):nth-child(2):nth-last-child(4) + TD[colspan=""4""]:not([rowspan]):nth-child(3):nth-last-child(3), TABLE > * > TR > TD[colspan=""2""]:not([rowspan]):nth-child(1):nth-last-child(6) + TD[colspan=""2""]:not([rowspan]):nth-child(2):nth-last-child(5) + TD[colspan=""4""]:not([rowspan]):nth-child(3):nth-last-child(4)"}, {"Column6", "TABLE > * > TR > TD[colspan=""2""]:not([rowspan]):nth-child(1):nth-last-child(5) + TD[colspan=""5""]:not([rowspan]):nth-child(2):nth-last-child(4), TABLE > * > TR > TD[colspan=""14""]:not([rowspan]):nth-child(1):nth-last-child(1), TABLE > * > TR > TD:not([colspan]):not([rowspan]):nth-child(1):nth-last-child(14) + TD:not([colspan]):not([rowspan]):nth-child(2):nth-last-child(13) + TD:not([colspan]):not([rowspan]):nth-child(3):nth-last-child(12) + TD:not([colspan]):not([rowspan]):nth-child(4):nth-last-child(11) + TD:not([colspan]):not([rowspan]):nth-child(5):nth-last-child(10) + TD:not([colspan]):not([rowspan]):nth-child(6):nth-last-child(9), TABLE > * > TR > TD[colspan=""9""]:not([rowspan]):nth-child(1):nth-last-child(3), TABLE > * > TR > TD:not([colspan]):not([rowspan]):nth-child(1):nth-last-child(5) + TD:not([colspan]):not([rowspan]):nth-child(2):nth-last-child(4) + TD:not([colspan]):not([rowspan]):nth-child(3):nth-last-child(3) + TD[colspan=""10""]:not([rowspan]):nth-child(4):nth-last-child(2), TABLE > * > TR > TD[colspan=""10""]:not([rowspan]):nth-child(1):nth-last-child(5), TABLE > * > TR > TD[colspan=""12""]:not([rowspan]):nth-child(1):nth-last-child(2), TABLE > * > TR > TD[colspan=""10""]:not([rowspan]):nth-child(1):nth-last-child(3), TABLE > * > TR > TD:not([colspan]):not([rowspan]):nth-child(1):nth-last-child(10) + TD:not([colspan]):not([rowspan]):nth-child(2):nth-last-child(9) + TD:not([colspan]):not([rowspan]):nth-child(3):nth-last-child(8) + TD:not([colspan]):not([rowspan]):nth-child(4):nth-last-child(7) + TD:not([colspan]):not([rowspan]):nth-child(5):nth-last-child(6) + TD:not([colspan]):not([rowspan]):nth-child(6):nth-last-child(5), TABLE > * > TR > TD[colspan=""13""]:not([rowspan]):nth-child(1):nth-last-child(1), TABLE > * > TR > TD[colspan=""2""]:not([rowspan]):nth-child(1):nth-last-child(5) + TD[colspan=""2""]:not([rowspan]):nth-child(2):nth-last-child(4) + TD[colspan=""4""]:not([rowspan]):nth-child(3):nth-last-child(3), TABLE > * > TR > TD[colspan=""2""]:not([rowspan]):nth-child(1):nth-last-child(6) + TD[colspan=""2""]:not([rowspan]):nth-child(2):nth-last-child(5) + TD[colspan=""4""]:not([rowspan]):nth-child(3):nth-last-child(4)"}, {"Column7", "TABLE > * > TR > TD[colspan=""2""]:not([rowspan]):nth-child(1):nth-last-child(5) + TD[colspan=""5""]:not([rowspan]):nth-child(2):nth-last-child(4), TABLE > * > TR > TD[colspan=""14""]:not([rowspan]):nth-child(1):nth-last-child(1), TABLE > * > TR > TD:not([colspan]):not([rowspan]):nth-child(1):nth-last-child(14) + TD:not([colspan]):not([rowspan]):nth-child(2):nth-last-child(13) + TD:not([colspan]):not([rowspan]):nth-child(3):nth-last-child(12) + TD:not([colspan]):not([rowspan]):nth-child(4):nth-last-child(11) + TD:not([colspan]):not([rowspan]):nth-child(5):nth-last-child(10) + TD:not([colspan]):not([rowspan]):nth-child(6):nth-last-child(9) + TD:not([colspan]):not([rowspan]):nth-child(7):nth-last-child(8), TABLE > * > TR > TD[colspan=""9""]:not([rowspan]):nth-child(1):nth-last-child(3), TABLE > * > TR > TD:not([colspan]):not([rowspan]):nth-child(1):nth-last-child(5) + TD:not([colspan]):not([rowspan]):nth-child(2):nth-last-child(4) + TD:not([colspan]):not([rowspan]):nth-child(3):nth-last-child(3) + TD[colspan=""10""]:not([rowspan]):nth-child(4):nth-last-child(2), TABLE > * > TR > TD[colspan=""10""]:not([rowspan]):nth-child(1):nth-last-child(5), TABLE > * > TR > TD[colspan=""12""]:not([rowspan]):nth-child(1):nth-last-child(2), TABLE > * > TR > TD[colspan=""10""]:not([rowspan]):nth-child(1):nth-last-child(3), TABLE > * > TR > TD:not([colspan]):not([rowspan]):nth-child(1):nth-last-child(10) + TD:not([colspan]):not([rowspan]):nth-child(2):nth-last-child(9) + TD:not([colspan]):not([rowspan]):nth-child(3):nth-last-child(8) + TD:not([colspan]):not([rowspan]):nth-child(4):nth-last-child(7) + TD:not([colspan]):not([rowspan]):nth-child(5):nth-last-child(6) + TD:not([colspan]):not([rowspan]):nth-child(6):nth-last-child(5) + TD:not([colspan]):not([rowspan]):nth-child(7):nth-last-child(4), TABLE > * > TR > TD[colspan=""13""]:not([rowspan]):nth-child(1):nth-last-child(1), TABLE > * > TR > TD[colspan=""2""]:not([rowspan]):nth-child(1):nth-last-child(5) + TD[colspan=""2""]:not([rowspan]):nth-child(2):nth-last-child(4) + TD[colspan=""4""]:not([rowspan]):nth-child(3):nth-last-child(3), TABLE > * > TR > TD[colspan=""2""]:not([rowspan]):nth-child(1):nth-last-child(6) + TD[colspan=""2""]:not([rowspan]):nth-child(2):nth-last-child(5) + TD[colspan=""4""]:not([rowspan]):nth-child(3):nth-last-child(4)"}, {"Column8", "TABLE > * > TR > TD[colspan=""2""]:not([rowspan]):nth-child(1):nth-last-child(5) + TD[colspan=""5""]:not([rowspan]):nth-child(2):nth-last-child(4) + TD[colspan=""2""]:not([rowspan]):nth-child(3):nth-last-child(3), TABLE > * > TR > TD[colspan=""14""]:not([rowspan]):nth-child(1):nth-last-child(1), TABLE > * > TR > TD:not([colspan]):not([rowspan]):nth-child(1):nth-last-child(14) + TD:not([colspan]):not([rowspan]):nth-child(2):nth-last-child(13) + TD:not([colspan]):not([rowspan]):nth-child(3):nth-last-child(12) + TD:not([colspan]):not([rowspan]):nth-child(4):nth-last-child(11) + TD:not([colspan]):not([rowspan]):nth-child(5):nth-last-child(10) + TD:not([colspan]):not([rowspan]):nth-child(6):nth-last-child(9) + TD:not([colspan]):not([rowspan]):nth-child(7):nth-last-child(8) + TD:not([colspan]):not([rowspan]):nth-child(8):nth-last-child(7), TABLE > * > TR > TD[colspan=""9""]:not([rowspan]):nth-child(1):nth-last-child(3), TABLE > * > TR > TD:not([colspan]):not([rowspan]):nth-child(1):nth-last-child(5) + TD:not([colspan]):not([rowspan]):nth-child(2):nth-last-child(4) + TD:not([colspan]):not([rowspan]):nth-child(3):nth-last-child(3) + TD[colspan=""10""]:not([rowspan]):nth-child(4):nth-last-child(2), TABLE > * > TR > TD[colspan=""10""]:not([rowspan]):nth-child(1):nth-last-child(5), TABLE > * > TR > TD[colspan=""12""]:not([rowspan]):nth-child(1):nth-last-child(2), TABLE > * > TR > TD[colspan=""10""]:not([rowspan]):nth-child(1):nth-last-child(3), TABLE > * > TR > TD:not([colspan]):not([rowspan]):nth-child(1):nth-last-child(10) + TD:not([colspan]):not([rowspan]):nth-child(2):nth-last-child(9) + TD:not([colspan]):not([rowspan]):nth-child(3):nth-last-child(8) + TD:not([colspan]):not([rowspan]):nth-child(4):nth-last-child(7) + TD:not([colspan]):not([rowspan]):nth-child(5):nth-last-child(6) + TD:not([colspan]):not([rowspan]):nth-child(6):nth-last-child(5) + TD:not([colspan]):not([rowspan]):nth-child(7):nth-last-child(4) + TD:not([colspan]):not([rowspan]):nth-child(8):nth-last-child(3), TABLE > * > TR > TD[colspan=""13""]:not([rowspan]):nth-child(1):nth-last-child(1), TABLE > * > TR > TD[colspan=""2""]:not([rowspan]):nth-child(1):nth-last-child(5) + TD[colspan=""2""]:not([rowspan]):nth-child(2):nth-last-child(4) + TD[colspan=""4""]:not([rowspan]):nth-child(3):nth-last-child(3), TABLE > * > TR > TD[colspan=""2""]:not([rowspan]):nth-child(1):nth-last-child(6) + TD[colspan=""2""]:not([rowspan]):nth-child(2):nth-last-child(5) + TD[colspan=""4""]:not([rowspan]):nth-child(3):nth-last-child(4)"}, {"Column9", "TABLE > * > TR > TD[colspan=""2""]:not([rowspan]):nth-child(1):nth-last-child(5) + TD[colspan=""5""]:not([rowspan]):nth-child(2):nth-last-child(4) + TD[colspan=""2""]:not([rowspan]):nth-child(3):nth-last-child(3), TABLE > * > TR > TD[colspan=""14""]:not([rowspan]):nth-child(1):nth-last-child(1), TABLE > * > TR > TD:not([colspan]):not([rowspan]):nth-child(1):nth-last-child(14) + TD:not([colspan]):not([rowspan]):nth-child(2):nth-last-child(13) + TD:not([colspan]):not([rowspan]):nth-child(3):nth-last-child(12) + TD:not([colspan]):not([rowspan]):nth-child(4):nth-last-child(11) + TD:not([colspan]):not([rowspan]):nth-child(5):nth-last-child(10) + TD:not([colspan]):not([rowspan]):nth-child(6):nth-last-child(9) + TD:not([colspan]):not([rowspan]):nth-child(7):nth-last-child(8) + TD:not([colspan]):not([rowspan]):nth-child(8):nth-last-child(7) + TD:not([colspan]):not([rowspan]):nth-child(9):nth-last-child(6), TABLE > * > TR > TD[colspan=""9""]:not([rowspan]):nth-child(1):nth-last-child(3), TABLE > * > TR > TD:not([colspan]):not([rowspan]):nth-child(1):nth-last-child(5) + TD:not([colspan]):not([rowspan]):nth-child(2):nth-last-child(4) + TD:not([colspan]):not([rowspan]):nth-child(3):nth-last-child(3) + TD[colspan=""10""]:not([rowspan]):nth-child(4):nth-last-child(2), TABLE > * > TR >
User | Count |
---|---|
93 | |
84 | |
78 | |
75 | |
66 |
User | Count |
---|---|
115 | |
105 | |
93 | |
65 | |
60 |