Forum Discussion
How can I specify NULL in the below Power Query?
Hello
I have the below Power Query:
#"Empty Row Added" = Table.InsertRows(#"Sorted Rows", 0,{Record.FromList(List.Repeat({""},Table.ColumnCount(#"Sorted Rows")),Table.ColumnNames(#"Sorted Rows"))})
I think, it adds a new row with the same columns and it populates the cells with "".
How can I use the same code but populate the columns with NULL?
Thanks!
Anonymous
Replace "" with null= Table.InsertRows(#"Sorted Rows", 0,{Record.FromList(List.Repeat({null},Table.ColumnCount(#"Sorted Rows")),Table.ColumnNames(#"Sorted Rows"))})________________________
If my answer was helpful, please consider Accept it as the solution to help the other members find it
Click on the Thumbs-Up icon if you like this reply 🙂
1 Reply
Anonymous
Replace "" with null= Table.InsertRows(#"Sorted Rows", 0,{Record.FromList(List.Repeat({null},Table.ColumnCount(#"Sorted Rows")),Table.ColumnNames(#"Sorted Rows"))})________________________
If my answer was helpful, please consider Accept it as the solution to help the other members find it
Click on the Thumbs-Up icon if you like this reply 🙂