Forum Discussion
Column Data Type mixed numeric and text for calculations
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 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".
In the Query editor window, try to cancel any change type steps and change that column to text from the Source step.
3 Replies
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".
In the Query editor window, try to cancel any change type steps and change that column to text from the Source step.
Ahh yes, I re-did the column value type and now it works.
Thanks
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.
