Field not found

M_Lhermitte — Sat, 16 Nov 2024 17:37:15 GMT

hi everyone,

could you please help me with this issue? when loading data, Qlik tells me the field "CustomerType" is not found. If I delete it, then the next field that is in the "where" clause is not found etc.

Any idea to solve this issue?

Thank you,

Marguerite

the script is:

NoConcatenate
[inst_per_course_1]:

Load
CourseIdentifier,
TraineeIdentifier,

count(DISTINCT Trigram) as nb_instructor

resident [RawData_LOAD]
where match([CustomerType], 'Airline', 'Internal') and match([EquipmentType], 'APT', 'FBS', 'FFS', 'FTD', 'FNPT')
and match(Competence, 'PG', 'PH')
group by CourseIdentifier, TraineeIdentifier
;

NoConcatenate
[inst_per_course_2]:

Load
CourseIdentifier,
nb_instructor,
if(nb_instructor = '1', '1',
if(nb_instructor = '2', '2',
if(nb_instructor = '3', '3',
if(nb_instructor = '4', '4',
if(nb_instructor = '5', '5',
if(nb_instructor = '6', '6',
if(nb_instructor = '7', '7',
if(nb_instructor = '8', '8', nb_instructor)))))))) as nb_instructor_per_trainee

resident [inst_per_course_1]
;

Re: Field not found

Anil_Babu_Samineni — Tue, 12 Jan 2021 18:33:41 GMT

@M_Lhermitte wrote:

NoConcatenate
[inst_per_course_1]:
Load
CourseIdentifier,
TraineeIdentifier,
[EquipmentType],
[CustomerType],
count(DISTINCT Trigram) as nb_instructor
resident [RawData_LOAD]
where match([CustomerType], 'Airline', 'Internal') and match([EquipmentType], 'APT', 'FBS', 'FFS', 'FTD', 'FNPT')
and match(Competence, 'PG', 'PH')
group by CourseIdentifier, TraineeIdentifier, [EquipmentType], [CustomerType];

I see that red part is missing..

topic Re: Field not found in App Development

Field not found

Re: Field not found