Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
EdsonGomes
Frequent Visitor

Transforma Tabela Power Query.

Olá, como transformar a 1º Tabela, para ficar igual a 2º Tabela?

Reparem que a coluna 1 e coluna 2 tem valores repetidos.

Duvidas Power Bi..PNG

 

 

 

 

 

 

 

 

 

 

 

Obrigado.

1 ACCEPTED SOLUTION
BA_Pete
Super User
Super User

Hi @EdsonGomes ,

 

Paste this into a new blank query to see the steps I took:

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMjRS0lEKLE3MUShOLVXIy89NtQcKuJXmJOblGyrF6kBVFJcmKmSmJKakAtnGpqjiyTCJIC+EBA4jjbAbaWSMw8jgAIiEMW4jjREqsLnSGN1IX3el2FgA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [id = _t, pregunta = _t, resposta = _t]),
    chgTypes = Table.TransformColumnTypes(Source,{{"id", Int64.Type}, {"pregunta", type text}, {"resposta", type text}}),
    addNomeColumn = Table.AddColumn(chgTypes, "nome", each if [pregunta] = "Qual seu nome?" then [resposta] else null),
    fillDownNomeColumn = Table.FillDown(addNomeColumn,{"nome"}),
    pivotPreguntaColumn = Table.Pivot(fillDownNomeColumn, List.Distinct(fillDownNomeColumn[pregunta]), "pregunta", "resposta")
in
    pivotPreguntaColumn

 

This give the following output:

BA_Pete_0-1646063036068.png

 

Pete



Now accepting Kudos! If my post helped you, why not give it a thumbs-up?

Proud to be a Datanaut!




View solution in original post

2 REPLIES 2
EdsonGomes
Frequent Visitor

Obrigado, funcionou 🙂

BA_Pete
Super User
Super User

Hi @EdsonGomes ,

 

Paste this into a new blank query to see the steps I took:

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMjRS0lEKLE3MUShOLVXIy89NtQcKuJXmJOblGyrF6kBVFJcmKmSmJKakAtnGpqjiyTCJIC+EBA4jjbAbaWSMw8jgAIiEMW4jjREqsLnSGN1IX3el2FgA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [id = _t, pregunta = _t, resposta = _t]),
    chgTypes = Table.TransformColumnTypes(Source,{{"id", Int64.Type}, {"pregunta", type text}, {"resposta", type text}}),
    addNomeColumn = Table.AddColumn(chgTypes, "nome", each if [pregunta] = "Qual seu nome?" then [resposta] else null),
    fillDownNomeColumn = Table.FillDown(addNomeColumn,{"nome"}),
    pivotPreguntaColumn = Table.Pivot(fillDownNomeColumn, List.Distinct(fillDownNomeColumn[pregunta]), "pregunta", "resposta")
in
    pivotPreguntaColumn

 

This give the following output:

BA_Pete_0-1646063036068.png

 

Pete



Now accepting Kudos! If my post helped you, why not give it a thumbs-up?

Proud to be a Datanaut!




Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors