How to deal with Header truncation

Hi there, I'm importing an xls file into designer and noticed that the first cell (A1) is being truncated after it's import as a header.

The issue is resolved when the same file is saved as an xlsx.

Was wondering if there's a way to prevent the truncation when using the file in xls format?

I'm trying to use the test tool to test if the first cell contains the word "Final" but due to the truncation its not working.

Screenshot 2021-05-18 at 6.25.12 PM.png

Screenshot 2021-05-18 at 6.25.40 PM.png

Screenshot 2021-05-18 at 6.29.50 PM.png

Input

Download

Data Investigation

Database Connection

Accepted answers

mceleavey

Hi @domlow ,

Unfortunately this is a limitation of the field names in the old .xls version of Excel (uncompressed).

The only way around this is to load this in without headers, treating the first row as data as this will not be truncated, then dynamically renaming from the first row:

Hope this helps.

All comments

mceleavey

Hi @domlow ,

can you post your data so we can look at this for you?

domlow

Adding the recreated data sets saved in xls and xlsx respectively.

Data Sample.xls

Data Sample.xlsx

domlow

@mceleavey attached

Quick Links

This months top contributors

AkimasaKajitani 389

mceleavey 388

mbarone 337

Hollingsworth 335

LanisC 335