If I understand the issue you have a string (text) filed that Tableau mis-interpreted as a number
you can just re cast it
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
I recasted it, but unfortunately it is not working. The values are do not exist in Tableau at this point.
They are missing already on the Data source screen. I imagine that when Tableau was importing the data, it saw a string in a list of numbers and said "What is this? I don't even care about it." and just threw it away.
My question is if I can somehow prevent this loss at the import stage.
I've never seen that happen before - are you sure you don't have a data source filter that is filtering out the field during the import process
After changing the format in the data source to string, I can update the data and finally the values are there. It wasn't working before, but now it is working, so that's important.
Thanks for the help.