Hi!
I'm trying to join two tables (for a pivot table).

The Excel warning response is:
"We couldn't get the data from the Data Model. Here's the error message we got:
Cannot convert value UP3135VZ' of type Text to type Interger. The following system error occured: Type mismatch"

One with with 9 records (all numerics) in the joining column & the other joining column has over 14,000 records (which includes these numberics and other alphanumerics) but they will not join unless I remove all the alphanumeric records.

This seems less than ideal to me but I can't work else I can do!!! I might need to match a permit starting with a letter... then I'm really stuck!

I've tried changing the cell format to text, general and even numbers - none of those worked!

Table 1
Permit Months
401929 19
102123 07

Table 2
Permit Band
UP3135VZ P
XS28UI A
PO27IU C
401929 D
102123 E

Do you know what I'm doing wrong?

Many thanks

Claire