Forum Discussion
Removing Blocks - Data Preparation
Hi, I'm looking to prepare my data with repeating blocks. Could anyone please help me as to how to remove the first block only (1-null)? ColumnA ColumnB 1 a 2 c 3 d nu...
Anonymous Ah, try this:
let Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMlTSUUpUitWJVjICspLBLGMgKwXMyivNyQFyisEcU7hSqHAamGMIZ4FMKEJWUKoUGwsA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [ColumnA = _t, ColumnB = _t]), #"Changed Type" = Table.TransformColumnTypes(Source,{{"ColumnA", Int64.Type}, {"ColumnB", type text}}), #"Added Index" = Table.AddIndexColumn(#"Changed Type", "Index", 0, 1, Int64.Type), #"Sorted Rows" = Table.Sort(#"Added Index",{{"Index", Order.Ascending}}), FirstNull = List.PositionOf(Table.Column(#"Sorted Rows","ColumnA"), null), FinalTable = Table.SelectRows(#"Sorted Rows",each [Index]>FirstNull) in FinalTable
Thank you 🙂