Forum Discussion
Solved
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...
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 ,
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.