Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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!