Can't correctly call excel column

[#1]

I am tasked with uploading data to a dashboard I have been working on. The new month data just came in and an error popped up. The leaders had added a (mm/dd/yy) to the column title, which wouldn't be a problem, except it is on a whole new line, like they hit the enter key. Does anyone know how to pull a field from an excel sheet that has an enter key like function inside it?

[MarcoWedel]

let the import wizard create the load statement and rename the field using "as".

hope this helps

regards

Marco

[MarcoWedel]

like this:

table1:
LOAD
[column name
with line break],
[column name
with line break] as NewName
FROM QlikCommunity_Thread_128499.xlsx
(ooxml, embedded labels, table is Tabelle1);

table2:
LOAD
  A as NewName2
FROM QlikCommunity_Thread_128499.xlsx
(ooxml, no labels, header is 1 lines, table is Tabelle1);

regards

Marco

[MarcoWedel]

Table 2 is created renaming all the fields during load (Without embedded labels).

regards

Marco