Forum

Columns are added a...
 
Notifications
Clear all

Columns are added and not realy deleted

3 Posts
3 Users
0 Reactions
164 Views
(@Anonymous)
Posts: 0
New Member Guest
 

Hi,

The file attached has 2 unneeded columns (Plot2 & Year3).

These columns were added to the file and cannot actually be deleted. Trying to delete result in strange behaviour, like 1 column is deleted but not the other, or it add another column.

You can see in the PQ steps that those columns were never added.

 

Regards,

Ayal Telem.

 
Posted : 21/10/2024 7:31 am
(@j8150outlook-com)
Posts: 51
Trusted Member
 

Poping topic up since there is no reply, which I find odd.

 

Regards,

Ayal Telem.

 
Posted : 29/10/2024 1:37 am
Anders Sehlstedt
(@sehlsan)
Posts: 971
Prominent Member
 

Hello,

If you remove the AllYears query, you can then delete those two columns in the table and then add the AllYears table into Power Query again.

Br,
Anders

 
Posted : 29/10/2024 4:40 pm
Share: