
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
ALIAS NOT WORKING
Hi,
I have a load script in which i use several alias statements to rename fields as to harmonize datasources.
This all works likes a charm 🙂
However, the data I need stems from several excel files and there is one field in the excel sheet which, when loaded in qliksense, gets represented in 2 lines.
My load script looks something like this:
ALIAS FIELD_1 AS RENAMEDFIELD_1
ALIAS FIELD_2 AS RENAMEDFIELD_2
ALIAS FIELD_
SOMEOTHERTEXT_3 AS RENAMEDFIELD_3
LOAD
*
FROM [LIB://mystorage/myfile.xlsx]
(ooxml,embedded labels, table is tabel)
The field
FIELD_
SOMEOTHERTEXT_3
is generated from the source table but the alias field does not work on this field.
Do you have a workaround for this issue?
Thanks 🙂
.png)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hello 🙌 I'm not 100% sure I've fully got your issue. Could you please share a sample script? Also, is the script processed correctly in the end? I mean, is the field loaded correctly (just not with the alias you have set)?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @Andrea_Spinetti @Kain_F ,
I am also facing similar issue with alias when I fetch data from Oracle database.
Example script like below
select
abc1 as abc11,
abc2 as abc22,
abc3 as abc33,
abc4 as abc44,
abc5 as abc55,
abc6 as abc66
from table;
Here Qlik Sense will give Oracle error saying Invalid identifier abc66.
and if we remove alias it works fine
Thanks
Aniket


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
What happens if you perform this action within a preceding-load, like:
load
abc1 as abc11,
abc2 as abc22,
abc3 as abc33,
abc4 as abc44,
abc5 as abc55,
abc6 as abc66;
select
abc1,
abc2,
abc3,
abc4,
abc5,
abc6
from table;
- Marcus

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @aniketvasadkar_eq ,
My issue was that my source file an .xlsx file was and the columnames were written inline, this meant that they when they got cut off in excel qliksense took over the same formatting which made it impossible to rename them.
I had to change the sourcefile, which was easy bc it was an excel file.
I dont know if it is possible to select or deselect an inline feature, something like deselecting 'wrap text in headers'.
I hope this can help you
