Qlik Community

Qlik Sense Data Connectivity

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

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

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

 

 

 

 

 

 

 

 

 

 

4 Replies
Highlighted
Partner
Partner

Re: Field not found


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
Highlighted
Contributor III
Contributor III

Re: Field not found

thank you,

can i write in private ?

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Highlighted
Contributor III
Contributor III

Re: Field not found

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

Re: Field not found

can i write in private? with email?