Field not found

[M_Lhermitte]

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]
;

[Anil_Babu_Samineni]

---

@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..