Excel truncation error on Field Summary Output file

Hi All,

I am receiving a "Max character width supported by Excel for a single cell exceeded, 13778 characters were truncated. Fieldname: Layout record number 2 (also get same for record number 3 and 4.

Background:

Using just the data investigation tools of basic data profile and field summary tools and creating outputs for both. The error is on the field summary tool.

Looked over data set and there is no value greater than 255 characters.

How do I identify where the offending data is and is there any way to correct?

Thanks

Kimberly

Error Message

Output

Accepted answers

danilang

Hi @kimc745

This error will occur if you try to send the results of the R or I output to excel through an Output Tool. The issue is that the output of either of those is a single report snippet, which is long pcxml string

Excel tries to stick this snippet into a single cell and you get the overflow error.

Use a render tool to output the results to excel and it will interpret the pcxml and format the excel file accordingly.

Dan

All comments

danilang

Hi @kimc745

Excel tries to stick this snippet into a single cell and you get the overflow error.

Use a render tool to output the results to excel and it will interpret the pcxml and format the excel file accordingly.

Dan

alisonpitt

The max string length in the Field Summary tool is 44 characters, before it starts truncating. I have read that in other forum posts and I tested it myself 😊. Depending on what you're trying to do, there might be other workarounds for that field, like pairing Summarize with Sample, or similar.

I assume that was just a warning and not an error?

kimc745

It was an error message (conversion error specifically). The issue is solved - see the previous post from Dan. It was because i was outputting to excel directly with output tool. The one thing I wish I had was an error decoder translator. If it weren't for everyone in the community, I'd be stuck.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703