ALIAS NOT WORKING

[Kain_F]

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 🙂 

[Andrea_Spinetti]

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)?

[aniketvasadkar_eq]

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

[marcus_sommer]

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

[Kain_F]

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