Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Olá, como transformar a 1º Tabela, para ficar igual a 2º Tabela?
Reparem que a coluna 1 e coluna 2 tem valores repetidos.
Obrigado.
Solved! Go to Solution.
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:
Pete
Proud to be a Datanaut!
Obrigado, funcionou 🙂
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:
Pete
Proud to be a Datanaut!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.