cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Continued Contributor
Continued Contributor

Editor avanzado desde un origen de página web

Hola

Estoy trabajando con datos de una tabla HTML en un sitio web.

¿Hay alguna manera de ocultar todo el código HTML generado desde el origen de datos de la página web?

Es muy aburrido desplazarse hacia abajo todas estas filas cada vez para editar en el Editor avanzado.

saludos

 #"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""]:

If I can...
2 ACCEPTED SOLUTIONS

Accepted Solutions
Highlighted
Super User IV
Super User IV

Re: Editor avanzado desde un origen de página web

@gpiero - Tal vez intente separar ese paso en su propia función. A continuación, no se saturará la consulta principal.


---------------------------------------

@ me in replies or I'll lose your thread!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

Highlighted
Continued Contributor
Continued Contributor

Re: Editor avanzado desde un origen de página web

@Greg_Deckler

es muy probable que se refería a la solución a continuación.

El primer quey TbItemOverview contiene solo la instrucción para importar datos desde la página Web

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}}),

A continuación, en la nueva consulta, debería volver a crear el comando adecuado para modelar los datos.

Gracias por la dirección correcta.

saludos

If I can...

View solution in original post

8 REPLIES 8
Highlighted
Super User IV
Super User IV

Re: Editor avanzado desde un origen de página web

@gpiero - Tal vez intente separar ese paso en su propia función. A continuación, no se saturará la consulta principal.


---------------------------------------

@ me in replies or I'll lose your thread!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

Highlighted
Community Champion
Community Champion

Re: Editor avanzado desde un origen de página web

Hola @gpiero

No hay manera de ocultar todo el código HTML generado desde el origen de datos de la página web.

Sin embargo, copiaría el código M en el editor de Notepad++ y no usaría la palabra wrap, esto lo mostrará en una línea.

pranit828_0-1598204661239.png botón de ajuste de palabras en El Bloc de notas++

Una vez que mi edición está hecha, lo copiaría y pegaría de nuevo.


Hope it resolves your issue? Please consider accepting it as the solution to help the other members find it more quickly.


Appreciate your Kudos, Press the thumbs up button!!👍


Regards,
Pranit


Highlighted
Continued Contributor
Continued Contributor

Re: Editor avanzado desde un origen de página web

Hola @pranit828 ,

muchas gracias por su consejo. Por el momento no creo que sea la mejor solución para mí. Trabajar de esta manera significa, si uderstood bien, copiar y pegar n veces entre el Bloc de notas ++ y El editor avanzado aumentando los errores y problemas.

Gracias de nuevo

saludos

If I can...
Highlighted
Community Champion
Community Champion

Re: Editor avanzado desde un origen de página web

Hola @gpiero

En ese caso, No hay forma de ocultar todo el código HTML generado desde el origen de datos de la página web.


Hope it resolves your issue? Please consider accepting it as the solution to help the other members find it more quickly.


Appreciate your Kudos, Press the thumbs up button!!👍


Regards,
Pranit


Highlighted
Continued Contributor
Continued Contributor

Re: Editor avanzado desde un origen de página web

@Greg_Deckler

¿Significa que podría crear una especie de subrutina o una consulta independiente solo para importar datos?

Y luego abrir un nuevo quey para modelar datos y así sucesivamente?

¿Hay algún ejemplo para "encender la lámpara en mi mente"?

Gracias de antemano

saludos

If I can...
Highlighted
Continued Contributor
Continued Contributor

Re: Editor avanzado desde un origen de página web

@Greg_Deckler

Me refiero a la dimensión de mi problema!!!!!!

He truncado con Bloc de notas ++ menos de 20k characthers. Eran 36 mil!!!!

Dejar
Source - File.Contents("C:-Users-Giamp-OneDrive-TOL Data Cloud-Analysis 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]): nth-child(1):nth-last-child(1) 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-child(3):nth-child(3):nth-child(3):nth-child(3):nth-child(3):nth-child(3):nth-child(3):nth-child(3):nth-child(3):nth-child(3):nth-child(3):nth-child(3):nth-child(3):nth-child(3):nth-child(3):nth-child(3):nth-child(3):nth-child(3):nth-child(3):nth-child(3):nth-child(3):nth-child(3):nth-child(3):nth-child(3):-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):2):2):2):2):2):2):2):2):2):2):2):2):2):2):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 > TD :not([colspan]):not([rowspan]):nth-child(1):nth-last-child(14) + TD:not([colspan]):not([rowspan]):nth-child(nth-child(14) + TD:not([colspan]):not([rowspan]):nth-child(nth-child(14) 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(((3 [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) , TABLA > * > 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) :not([colspan]):not([rowspan]):nth-child(4):nth-last-child(7) + TD:not([colspan]):not([rowspan]):nth-child(-15):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([[[[nth-last-child(6) + TD[colspan-""2""]:not([[[[nth-last-child(6) + TD[colspan-""2""]:not([[[[[1-last-child(6) rowspan]):nth-child(2):nth-last-child(5) + TD[colspan-"""4""]:not([rowspan]):nth-child(3):nth-last-child(4)" , "Columna7", "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]):nth-last-child(1), TABLE > * > TR > TD:not([colspan]):):nth-last-child(1), TABLE > * > TR > TD:not([colspan]):nth-last-child(1), TABLE > * > TR > TD:not([colspan]):nth-last-child(1), TABLE > * > TR > TD:not([colspan]):):nth-last-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(nth-child(11) 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):2):2):2):2):2):2):2):2):2):2):2):2):2):2):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:13) 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(6):nth-last-child(9) + TD:not((([colspan]):not([rowspan]):nth-child(6):nth-last-child(9) + TD:not((([colspan]):not([rowspan]):nth-child(6):nth-last-child(9) + 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([colspanpan]):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 > * > 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-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 > TD :not([colspan]):not([rowspan]):nth-child(1):nth-last-child(14) + TD:not([colspan]):not([rowspan]):nth-child(2):nth-last-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): ([rows]nth- :nth-last-child(3) + TD[colspan-""10""]:not([rowspan]):nth-child(4):nth-last-child(2), TABLE > * > TR >

If I can...
Highlighted
Continued Contributor
Continued Contributor

Re: Editor avanzado desde un origen de página web

@Greg_Deckler

es muy probable que se refería a la solución a continuación.

El primer quey TbItemOverview contiene solo la instrucción para importar datos desde la página Web

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}}),

A continuación, en la nueva consulta, debería volver a crear el comando adecuado para modelar los datos.

Gracias por la dirección correcta.

saludos

If I can...

View solution in original post

Highlighted
Super User IV
Super User IV

Re: Editor avanzado desde un origen de página web

@gpiero - Sí, lo tienes, lo siento por no ser más específico!


---------------------------------------

@ me in replies or I'll lose your thread!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors