Qlik Community

Qlik Sense Data Connectivity

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

Billy_u
New 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
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 

Please ekskuse my Norglish and Swenglish typos.
Billy_u
New Contributor III

Re: Field not found

thank you,

can i write in private ?

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Billy_u
New Contributor III

Re: Field not found

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

Re: Field not found

can i write in private? with email?