Forum Discussion

joseluissa001's avatar
joseluissa001
Frequent Visitor
2 years ago
Solved

Range to columns

Hello, good afternoon community, I have a question about how to solve a problem that I have encountered. I have a file that is filled out with a Microsoft form, these are vehicle inspection procedur...
Need Help
  • Syndicate_Admin's avatar
    Syndicate_Admin
    2 years ago
    let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WcspPUtJRcgpwNAICHYUAX0dzIAAyfBwtgEApVidaySu/OAOoyNfRxdLC3EJHwcfF2dTE3FRHwdHRxdzYzFIpNhYA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Client = _t, registration = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Client", type text}, {"registration", type text}}),
    #"Split Column by Delimiter" = Table.ExpandListColumn(Table.TransformColumns(#"Changed Type", {{"registration", Splitter.SplitTextByDelimiter(",", QuoteStyle.Csv), let itemType = (type nullable text) meta [Serialized.Text = true] in type {itemType}}}), "registration"),
    #"Changed Type1" = Table.TransformColumnTypes(#"Split Column by Delimiter",{{"registration", type text}})
in
    #"Changed Type1"
Syndicate_Admin's avatar
Syndicate_Admin
Administrator
2 years ago
let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WcspPUtJRcgpwNAICHYUAX0dzIAAyfBwtgEApVidaySu/OAOoyNfRxdLC3EJHwcfF2dTE3FRHwdHRxdzYzFIpNhYA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Client = _t, registration = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Client", type text}, {"registration", type text}}),
    #"Split Column by Delimiter" = Table.ExpandListColumn(Table.TransformColumns(#"Changed Type", {{"registration", Splitter.SplitTextByDelimiter(",", QuoteStyle.Csv), let itemType = (type nullable text) meta [Serialized.Text = true] in type {itemType}}}), "registration"),
    #"Changed Type1" = Table.TransformColumnTypes(#"Split Column by Delimiter",{{"registration", type text}})
in
    #"Changed Type1"