Forum Discussion
Hide blank column
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.
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.
