danhendo888
Board Regular
- Joined
- Jul 15, 2019
- Messages
- 167
- Office Version
- 365
- Platform
- Windows
Table1: Among many columns, I have a column with whole numbers and also text.
In PQ, I will do a Merge on the above table with another lookup table (Table2). It seems to work fine in PQ editor since I can expand the new column from Table2.
But when I try to Load To as a pivot table or Table, I get the error: [DataFormat.Error] We couldn't convert to Number.
It seems the error is caused by the column mentioned in Table1.
I'm not sure what I'm missing here. Perhaps there is something I'm overlooking? When doing a Merge on the column from Table1 (with numbers and text), should it only be one data type?
In PQ, I will do a Merge on the above table with another lookup table (Table2). It seems to work fine in PQ editor since I can expand the new column from Table2.
But when I try to Load To as a pivot table or Table, I get the error: [DataFormat.Error] We couldn't convert to Number.
It seems the error is caused by the column mentioned in Table1.
I'm not sure what I'm missing here. Perhaps there is something I'm overlooking? When doing a Merge on the column from Table1 (with numbers and text), should it only be one data type?