Qlik Community

Ask a Question

Connectivity & Data Prep

Discussion board where members can learn more about Qlik Sense Data Connectivity.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Billy_u
Creator
Creator

Field not found

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

 

 

 

 

 

 

 

 

 

 

Labels (4)
4 Replies
Vegar
MVP
MVP


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 

Plees ekskuse my Swenglish and or Norweglish spelling misstakes
Billy_u
Creator
Creator
Author

thank you,

can i write in private ?

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Billy_u
Creator
Creator
Author

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

can i write in private? with email?