Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Insert blank row at the end

I can insert a blank row using this code:

 

= Table.InsertRows(Source, 0,{Record.FromList(List.Repeat({""},Table.ColumnCount(Source)),Table.ColumnNames(Source))})

 

but the zero inserts at the beginnng of the table.

I would like to insert the blank row at the last row.

 

 

I tried using Table.PositionOf(Source, RowAsRecord) but do not know how to extract the RowAsRecord.   

 

 Table.LastN(Source, 1)    // locates the row, but is not a record type.

 

     Finally I tried converting it to a record, but is not in the format [name="", value=""]

 

Record.FromTable(Table.LastN(Source, 1))

 

 

Hence, this code does not work:

 

= Table.InsertRows(Source, 

  Table.PositionOf(Source, 
		Record.FromTable(Table.LastN(Source, 1))),
		
  {Record.FromList(List.Repeat({""},Table.ColumnCount(Source)),Table.ColumnNames(Source))})

 

 

Please advise. Thank you!

  • Anonymous's avatar
    Anonymous
    2 years ago

    Replace the "0" with Table.RowCount(Source). This will give you the row count, which is one more than the zero based index of the last row.

     

    --Nate

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Replace the "0" with Table.RowCount(Source). This will give you the row count, which is one more than the zero based index of the last row.

     

    --Nate

  • Anonymous's avatar
    Anonymous
    Not applicable

    Thank you Anonymous that was easy!