Connectivity & Data Prep

[Billy_u]

Hi everyone,

i have to update the data,

i have to replace the excel files,

the Qlik code reads in two source folders, these two folders differ in the language,

in the excel file changes the name of two keys field, previously were in the same language between two folders

 now instead changes and does not find me the fields,

but since the process is automatic I cannot identify where I need to solve the problem

[Vegar]

You might solve this issue by using the ALIAS function.

ALIAS SwedishFieldname as Fieldname, NorwegianFieldname as Fieldname;

AllData:
LOAD 
  'A' as SwedishFieldname  ,
  3 as Value
Autogenerate 1;

CONCATENATE LOAD 
  'B' as NorwegianFieldname   ,
   2 as Value
Autogenerate 1;

CONCATENATE LOAD 
  'C' as Fieldname   ,
   1 as Value
Autogenerate 1;

Read more in the Qlik help - alias 

[Billy_u]

thank you,

can i write in private ?

[Billy_u]

thank you, but i don't understand where i can insert this script

[Billy_u]

can i write in private? with email?