Forum Discussion
Hide blank column
Hi,
I have created blank column in Power Query by using the following step.
#"Added Custom" = Table.AddColumn(#"Sorted Rows", " ", each "")
However, I don't want this column to appear in the final results. Is there a way to hide the column when the data is closed and loaded?
Transpose option doesn't help to hide the column. Thank you!
Hi vineshparekh, if you do not need this column in final result, just delete it.
- in power query you should use null value instead of "".
- what is/was the purpose of creating column with name space and "" in every row?
hi vineshparekh ,
to hide a column once loaded into the model:
1. select the elipsis:
2. hide
regardless, i agree with dufoq3 , if you don't need the column, might as well remove it in power query before loading.
3 Replies
Hi vineshparekh, if you do not need this column in final result, just delete it.
- in power query you should use null value instead of "".
- what is/was the purpose of creating column with name space and "" in every row?
Hi dufoq3
I have PDFs coming each month and this query adds a column for the current month invoices.
For example,
Feb/24 and the next month it will add a column automatically with Mar/24 based on invoice. After the last column, I have few columns in Excel (Not connected to query) where it shows formula. Since there is a division between two sets of data, the query doesn't use the same format I provided for the table to the new column. (Mar/24). I have to do the same formatting for the newly added column. Where as, if I have a blank column, the query applies the format to the new column keeping blank column at last.
hi vineshparekh ,
to hide a column once loaded into the model:
1. select the elipsis:
2. hide
regardless, i agree with dufoq3 , if you don't need the column, might as well remove it in power query before loading.
