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 

 

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"))})
ChemEnger's avatar
ChemEnger
Advocate V
3 years ago

Just to add that this won't create a truly empty row - it inserts "" and should instead use

List.Repeat(null)