Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
I have one column of data with multiple rows, shown below. What I need to do is create 6 columns and split the data out. See second image.
What I have today
What I need
Solved! Go to Solution.
Hi @rpalardy,
Result:
let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45W8g1RitUBUpk5+UU6CiEZmYl56WCRklyQEJjpWlEAZKZCODmJeiV5JXrJ+blgrpejn4KhsY6CkYERkDQ0tDI1U3D0BUuBCXdniBGZGSWl6ToKzkWVxSWZqWCx5FSwIKYVeVisMIJZYWxlYqoQgGRDsCuYckxJzM0sztBRcC3KTE6EGJoIEcO0IbEAwwZTuB+sTC3BXogFAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Column1 = _t]),
FilteredRows = Table.SelectRows(Source, each ([Column1] <> "")),
Transformed = Table.FromRows(List.Split(List.Transform(Table.ToList(FilteredRows), (x)=> Text.Remove(x, """")),6), {"Initials", "Name", "email", "user type", "appendix", "date"})
in
Transformed
Hi @rpalardy,
Result:
let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45W8g1RitUBUpk5+UU6CiEZmYl56WCRklyQEJjpWlEAZKZCODmJeiV5JXrJ+blgrpejn4KhsY6CkYERkDQ0tDI1U3D0BUuBCXdniBGZGSWl6ToKzkWVxSWZqWCx5FSwIKYVeVisMIJZYWxlYqoQgGRDsCuYckxJzM0sztBRcC3KTE6EGJoIEcO0IbEAwwZTuB+sTC3BXogFAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Column1 = _t]),
FilteredRows = Table.SelectRows(Source, each ([Column1] <> "")),
Transformed = Table.FromRows(List.Split(List.Transform(Table.ToList(FilteredRows), (x)=> Text.Remove(x, """")),6), {"Initials", "Name", "email", "user type", "appendix", "date"})
in
Transformed