Column Data Type mixed numeric and text for calculations

[jpt1228]

Hello, I have a model that is erroring out in a fact table. My Customer DIM table has a numeric value for all customers with the exception of 3 of them which are text. When I load the fact table the column errors out if I have it set as a numeric column. When I change it to text I get an error for the text customer "numbers".

[Eric_Zhang · Accepted solution]

---

@jpt1228 wrote:

Hello, I have a model that is erroring out in a fact table. My Customer DIM table has a numeric value for all customers with the exception of 3 of them which are text. When I load the fact table the column errors out if I have it set as a numeric column. When I change it to text I get an error for the text customer "numbers".

---

@jpt1228

In the Query editor window, try to cancel any change type steps and change that column to text from the Source step.

[sifar786]

@Eric_Zhang that is not a viable solution.

I am facing the same issue when importing a csv containing numbers formatted as text (12,345) and numeric (12345). How do i handle these as my table needs to be merged later with other table and also form a relationship once in the model view. 

[jpt1228]

Ahh yes, I re-did the column value type and now it works.

Thanks