Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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

Tags (3)
1 Solution

Accepted Solutions
mwoolf
Honored Contributor II

Load from Excel file with embedded labels containing multiple lines

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

2 Replies
mwoolf
Honored Contributor II

Load from Excel file with embedded labels containing multiple lines

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

Highlighted
Not applicable

Load from Excel file with embedded labels containing multiple lines

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

Community Browser