Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
chan103148
Contributor III
Contributor III

rename field name to be used as map_name

good day, please help me rename field in load editor so that i can use that as a connection in mapping load without having to change column name from external source.

unqualify *;
LOAD
[barcode] as [ALU],
[name]
FROM [lib://Desktop/Book11111.xlsx]
(ooxml, embedded labels, table is Sheet1);

 

[name]:
Mapping LOAD
[ALU],
[name]
FROM [lib://Desktop/Book11111.xlsx]
(ooxml, embedded labels, table is Sheet1);

 


[Sheet2]:
LOAD
[ALU],
ApplyMap('name',[ALU]) as [name]

FROM [lib://Desktop/Book11111.xlsx]
(ooxml, embedded labels, table is Sheet2);

Labels (2)
1 Reply
whiteymcaces
Partner
Partner

Can you please provide what your source tables contain and what you want the result table to contain.