Hi everyone,
When I load my data from a table in an sqlite file long strings get truncated, and unlike when I load csv-files I don't see a setting for determining max field length. Any suggestion on how I could load the full data would be much appreciated.
Thank you!
Solved! Go to Solution.
Hey @Tomas
Can you change the string length in your SQL query?
So it would be something like
Select Cast([Your Field] as VarChar(1000)) From YourTable
I'm guessing here
Part time Tableau, Part Time Alteryx. Full Time Awesome
Thanks Neil, that worked like a charm!
For completeness can you show me how to write a command that casts the field to varchar whilst also loading the other fields from the table. I guess:
Select *, Cast([Your Field] as VarChar(1000)) From YourTable
Followed by a select node where one deselects the truncated field would work, but is there a more elegant way?
Thank you.