Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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 (1)
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 

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?