cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
JVos Regular Visitor
Regular Visitor

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 = "", Percentage = "", Quantity = "", DisplaySequence = "", CheckUniqueness = "", CheckPercentage = "", CheckRCGRouteMaster = ""]})

 

However, when there will be a change in the source columns, the code is broken. How can I add the columns dynamically?

 

Probably it's something with Table.ColumnNames(#"Sorted Rows"), but this will only return the column names. How then to add the empty values?

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Insert empty row without explicitly specifying column names

@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"))})

View solution in original post

3 REPLIES 3
Super User
Super User

Re: Insert empty row without explicitly specifying column names

@JVos 

 

Try this alternative

 

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

Re: Insert empty row without explicitly specifying column names

@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"))})

View solution in original post

JVos Regular Visitor
Regular Visitor

Re: Insert empty row without explicitly specifying column names

@Zubair_Muhammad: Works perfectly, thank you!

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

New Badges

Incoming: New and Improved Badges

Exciting news: We've given our badges an overhaul and added brand news ones.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Top Kudoed Authors
Users Online
Currently online: 198 members 2,228 guests
Please welcome our newest community members: