Conversion Errors on Data Investigation Field Summary Tool

Question

Hi,

Kicking the tires on the Data Investigation tools.  I have a file that is mostly string and dates.  I was using the Field Summary to look at basic profiling; however, I am getting 22 Conversion errors that are:

Field Summary (6), Tool #275: Tool #122: Value "value of stuff comes in here" was truncated to 44 characters.

Field Summary (6), Tool #275: Tool #32: Value "value of stuff comes in here" was truncated to 44 characters.

I am importing an .xlsx file and there was no option on the import tool to increase the field length.

Any ideas what would be causing this or how to correct?

FrederikE · Answer

Hey @kimc745,

This tool doesn't allow longer strings.then 44 chars.

Since this tool is a macro you can change it yourself. Right-click on the tool and select "open macro".

You need to change this select tool (is in a macro (IFS) inside the tool)

Be aware that this might impact performance and there is probably a good reason there is this char-limit in there!