Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Load from Excel file with embedded labels containing multiple lines

I'm trying to produce a script to load from an Excel file with embedded labels containing multiple lines, e.g. attached file.

The script produced by Table Files button includes carriage return characters within the field name, e.g.

LOAD [Column

Heading]

FROM

Book1.xlsx

(ooxml, embedded labels, table is Sheet1)

and fails to find the field when I load, e.g.

Field not found - <Column

Heading>

LOAD [Column

Heading]

FROM

Book1.xlsx

(ooxml, embedded labels, table is Sheet1)

Does anyone know of a workaround that doesn't involve editing the source data file?

Thanks

1 Solution

Accepted Solutions
m_woolf
Master II
Master II

I have qv10 rr4 and have no problems loading from your Excel file.

View solution in original post

2 Replies
m_woolf
Master II
Master II

I have qv10 rr4 and have no problems loading from your Excel file.

Not applicable
Author

I have QV10 SR1. Guess I need to upgrade again. Thanks, Geoff