Forum Discussion

JVos's avatar
JVos
Helper IV
7 years ago
Solved

Insert empty row without explicitly specifying column names

For adding one empty row to the "Sorted rows" intermediate result I have the following code:   Table.InsertRows(#"Sorted Rows", 0, {[RoutingCropGroupCode = "", RouteName = "", LineNumber = "", Perc...
Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    7 years ago

    JVos 

     

    Also this one.

    This uses your Table.InsertRows method

     

    = Table.InsertRows(#"Sorted Rows", 0,{Record.FromList(List.Repeat({""},Table.ColumnCount(#"Sorted Rows")),Table.ColumnNames(#"Sorted Rows"))})
Zubair_Muhammad's avatar
Zubair_Muhammad
Community Champion
7 years ago

JVos 

 

Try this alternative

 

Table.Combine({
Table.FromColumns(List.Transform(List.Repeat({""},Table.ColumnCount(#"Sorted Rows")),each {_}),Table.ColumnNames(#"Sorted Rows")),
#"Sorted Rows"})