Import Data Truncation

My text field keeps getting truncated at 254, even after changing the field size, and the character set. Is this a version issue (we're on 10.5.9) or am I missing something?

Import Definition

Meta Data for Import Result

The actual results however show the red corner stating the field was truncated, and the max field size is 254.

Actual Result

Input

Accepted answers

MarqueeCrew

@Josh_,

Thanks for the data....

The input data was read and I put a formula tool after the read to see what the true length of the field is. The first record is 435 bytes and the second is 439. The browse everywhere does have a message that the field is > 256 characters (a limit for the visualization). The full data content is present in the data.

Does this help?

cheers,

Mark

Import Data Truncation.yxmd

All comments

MarqueeCrew

can you post a sample of the data with a few records please?

Thanks,

Mark

Josh_

Hi Mark,

Thanks for taking the time to look at this. The last screenshot shows some records from the import. I can't share the data files themselves, as they contain sensitive data.

Josh_

I created a sample file, and it has the same results. I am attaching both file and flow.

Thanks for your help.

test_set.csv.txt

wrapper_log_analysis.yxmd

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703