Forum

Pivot column return...
 
Notifications
Clear all

Pivot column returns "we couldn't convert to number"

3 Posts
2 Users
0 Reactions
203 Views
(@tracytkanalytics-co-za)
Posts: 38
Trusted Member
Topic starter
 

Hi Mynda,

 

In fact I get the error when I try to close and load as well.

 

I attach my excel file as requested.

 

tnx

Tracy.

 
Posted : 05/02/2019 4:09 am
(@mynda)
Posts: 4761
Member Admin
 

Hi Tracy,

In column 7 you have some text 'PlacementMonth'. If you filter that out after the 2nd step, which is Changed Type, then your data will load.

Mynda

 
Posted : 05/02/2019 7:14 pm
(@tracytkanalytics-co-za)
Posts: 38
Trusted Member
Topic starter
 

Thanks so much, you are the best (obviously!)

 
Posted : 06/02/2019 3:42 am
Share: