Alteryx truncates strings when loading sqlite

[Tomas]

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!

[LordNeilLord]

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

@LordNeilLord

Part time Tableau, Part Time Alteryx. Full Time Awesome

[Tomas]

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.

[LordNeilLord · Accepted solution]

Hey

It will be something like,

Select

ColumnA,
ColumnB,
Cast(ColumnC as Varchar(1000)) as ColumnC,
ColumnD

From Table

If you use the visual query builder to first select all of the columns that you need and the switch to the SQL editor to cast the column that is giving you the issue

Let me know how you get on and if you're happy mark this as accepted :)

Neil