Alteryx truncates strings when loading sqlite

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 Screenshoot.png

Input

Accepted answers

LordNeilLord

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

All comments

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

Data Lover

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.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703