Forum Discussion

JVos's avatar
JVos
Icon for Helper IV rankHelper 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
Icon for Community Champion rankCommunity 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"))})
  • JVos's avatar
    JVos
    Icon for Helper IV rankHelper IV
    7 years ago

    Zubair_Muhammad: Works perfectly, thank you!

  • ChemEnger's avatar
    ChemEnger
    Icon for Advocate V rankAdvocate 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)