community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Alteryx truncates strings when loading sqlite

Atom

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!

Alteryx Certified Partner

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


Data Lover

 

Atom

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.

Alteryx Certified Partner
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
Labels