Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
3 years ago

Transformación en Power Query

Hola juntos,

¿Alguien ahora cómo puedo transformar mi tabla de la vista anterior a la vista inferior en el Editor de PowerQuery?

Saludos

Flixy04

1 Reply

  • Syndicate_Admin's avatar
    Syndicate_Admin
    Icon for Administrator rankAdministrator
    3 years ago

    plse prueba esto

    let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMjQAA0MlHSUfEKFraqAUq4MqbgQkUIWNYMqBfAxxY5AxaBLGMHOMTDHFwRrQJExgEsZYxMEOBUvEAgA=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [BLG = _t, LORT = _t, EUR = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"BLG", type text}, {"LORT", type text}, {"EUR", Int64.Type}}),
    #"Grouped Rows" = Table.Group(#"Changed Type", {"BLG"}, {{"Count", ( t ) => { t{0}[BLG] } & t[LORT] & t[EUR], type list  }}),
    Custom1 = List.Sort ( #"Grouped Rows"[Count], ( x ) => - List.Count ( x ) ),
    Custom2 = Table.FromList (
    Custom1,
    ( x ) => x,
    { "BLG"} & List.Transform ( { 1 .. List.Count ( Custom1{0} ) - 1 }, ( y ) => "Column" & Text.From ( y ) )
  )
in
    Custom2