gheyman
Well-known Member
- Joined
- Nov 14, 2005
- Messages
- 2,347
- Office Version
- 365
- Platform
- Windows
I am looking at a Workbook someone else created.
When I look at the source of this table, it looks like this:
let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("fZLRasMwDEV/RfRphe4j0lDYIF2yNWMPJQ8h0YwgtoutFPr3c2iSOrWzF9tc3SOBrs/nzWevGeEVDkrAwTLJmnGzu8vuXsjVbvI74NRfLh2hga/86AEL+QF4/g8Ne2pjyFgZqCJ3SNJwX3cWXpI83TpjkbtjKT68V/EjGNtvRZxqy7P9WZ+JtDdXbMG938iyNrcJCQvrDPxqAyeSpV6lPcvcJxwam/bfmNX+R7KNY7MygUy79Eo0EhJhECWqYS2DwV1rBq/H8/5HMkxgyjjVUqJpqO6gMNSQEl7MkaLPvitGo5AjZFCaN5TVloc1+YmPWvzzTS2Dv3cXquoP", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [#"Source Type" = _t, Type = _t, Subcatagory = _t]),
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Source Type", type text}, {"Type", type text}, {"Subcatagory", type text}}),
#"Renamed Columns" = Table.RenameColumns(#"Changed Type",{{"Source Type", "SourceType"}}),
#"Sorted Rows" = Table.Sort(#"Renamed Columns",{{"SourceType", Order.Descending}, {"Subcatagory", Order.Ascending}})
in
#"Sorted Rows"
can someone please explain this? I am use to the table source being an excel table or a SQL Table view.... I have never seen this before and I have to add a row to it with new data.
When I look at the source of this table, it looks like this:
let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("fZLRasMwDEV/RfRphe4j0lDYIF2yNWMPJQ8h0YwgtoutFPr3c2iSOrWzF9tc3SOBrs/nzWevGeEVDkrAwTLJmnGzu8vuXsjVbvI74NRfLh2hga/86AEL+QF4/g8Ne2pjyFgZqCJ3SNJwX3cWXpI83TpjkbtjKT68V/EjGNtvRZxqy7P9WZ+JtDdXbMG938iyNrcJCQvrDPxqAyeSpV6lPcvcJxwam/bfmNX+R7KNY7MygUy79Eo0EhJhECWqYS2DwV1rBq/H8/5HMkxgyjjVUqJpqO6gMNSQEl7MkaLPvitGo5AjZFCaN5TVloc1+YmPWvzzTS2Dv3cXquoP", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [#"Source Type" = _t, Type = _t, Subcatagory = _t]),
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Source Type", type text}, {"Type", type text}, {"Subcatagory", type text}}),
#"Renamed Columns" = Table.RenameColumns(#"Changed Type",{{"Source Type", "SourceType"}}),
#"Sorted Rows" = Table.Sort(#"Renamed Columns",{{"SourceType", Order.Descending}, {"Subcatagory", Order.Ascending}})
in
#"Sorted Rows"
can someone please explain this? I am use to the table source being an excel table or a SQL Table view.... I have never seen this before and I have to add a row to it with new data.