Data truncation while loading csv file into alteryx

Hi Team,

All that i am trying to do is just load a csv file into alteryx. When i click refresh i see the values are truncated in fews rows. Could some one assist on how to get the values without truncation.

I tried the option of giving max field length too. but still seeing the values truncated.

Attached the screenshot too. cells truncated csv file.JPG

Workflow

Accepted answers

chuckleswk

@SrinivasanSugumaran, your data is not truncated. You will need to use the browse tool if you want to view all of the characters in the field displayed .

The results pane (highlighted in yellow) will always truncate the results displayed down to 255 characters..

All comments

chuckleswk

Are you getting the truncation when selecting the browse tool as well or in the output? If you are just viewing the results from the input tool then you will get a truncation when it's more than 255 characters. Check it at the browse tool (or further downstream) to see if you're getting the same truncation.

SrinivasanSugumaran

Hi @chuckleswk , i noticed that i didnt get any truncation in the browse tool, but in select tool there is truncation.

Luke_C

Hi @SrinivasanSugumaran

Is the truncation in the data itself or just in the results pane? @chuckleswk's point is valid that the results pane will truncate for presentation purposes only. If you put a browse after the select how does it look?

chuckleswk

@SrinivasanSugumaran, your data is not truncated. You will need to use the browse tool if you want to view all of the characters in the field displayed .

The results pane (highlighted in yellow) will always truncate the results displayed down to 255 characters..

SrinivasanSugumaran

@chuckleswk
@Luke_C
Thanks both. i tried exporting to excel .. there was no truncation.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15880

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703