topic Re: Field not found in Connectivity & Data Prep

Field not found

Billy_u — Thu, 23 Dec 2021 13:45:48 GMT

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

Re: Field not found

Vegar — Fri, 17 May 2019 13:27:36 GMT

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;

Re: Field not found

Billy_u — Fri, 17 May 2019 15:31:00 GMT

thank you,

can i write in private ?

Re: Field not found

Billy_u — Fri, 17 May 2019 15:33:14 GMT

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

Re: Field not found

Billy_u — Fri, 17 May 2019 15:33:42 GMT

can i write in private? with email?