Error with load xlsx files , "Field not found"

brunobertels — Wed, 21 May 2025 08:52:18 GMT

Hi all

I have each month an excel files with this format 01_ABCD_QUALIF_AI.xlsx where first two digit are the month

for example :

01_ABCD_QUALIF_AI.xlsx

02_ABCD_QUALIF_AI.xlsx

03_ABCD_QUALIF_AI.xlsx

I'am loading all excel files from a folder using ?? in the excel files name like that "??_ABCD_QUALIF_AI.xlsx" :

FROM [lib://QUALIF_2025 /??_ABCD_QUALIF_AI.xlsx]
(ooxml, embedded labels, table is [My Sheet])

it was working perfectly but this morning I have a script error field not found :

Chargement de données démarré

My Sheet Lignes extraites : 10 043

My Sheet << My Sheet Lignes extraites : 18 113

My Sheet << My Sheet Lignes extraites : 25 323

L'erreur suivante s'est produite:

Field 'ORIGINE' not found

Emplacement de l'erreur:

LOAD DOSSIER_RELATION, TYPE_DOSSIER_RELATION, NUM_PERSONNE, TYPE_ASSURE, IDFSYS_ACTION, date(date(floor(DATE_ACTION),'DD/MM/YYYY'),'DD/MM/YYYY') as DATE_ACTION, TYPE_ACTION, ORIGINE, LIB_ORIGINE_ACTION, ETAT, right(UTILISATEUR,5) as MATRICULE, replace([NOM_LONG],'DEL OGLIO','DELLOGLIO') as NOM_LONG, Capitalize(PRENOM) as PRENOM, RESEAU, AGENCE, RESULTAT, NATURE_APPELANT, ER_DOSSIER_RELATION, DERNIERE_ER_CONNUE, ENTITE_RATTACHEMENT_FINALE FROM [lib://QUALIF_2025/??_ABCD_QUALIF_AI.xlsx] (ooxml, embedded labels, table is [My Sheet]) where ORIGINE='RE' OR ORIGINE='AE'

Les données n'ont pas été chargées. Corrigez l'erreur, puis recommencez l'opération de chargement.

i checked the labels and everythink is OK

I tried to change the script like that :

LOAD
*
FROM [lib://QUALIF_2025/??_ABCD_QUALIF_AI.xlsx]
(ooxml, embedded labels, table is [My Sheet])
where ORIGINE='RE' OR ORIGINE='AE';

got the same error :

Chargement de données démarré

My Sheet Lignes extraites : 10 043 My Sheet << My Sheet

Lignes extraites : 18 113 My Sheet << My Sheet Lignes extraites : 25 323

L'erreur suivante s'est produite:

Field 'ORIGINE' not found

Emplacement de l'erreur:

LOAD * FROM [lib://QUALIF_2025/??_ABCD_QUALIF_AI.xlsx] (ooxml, embedded labels, table is [My Sheet]) where ORIGINE='RE' OR ORIGINE='AE'

Les données n'ont pas été chargées. Corrigez l'erreur, puis recommencez l'opération de chargement.

when I load the files one by one each script works perfectly :

load

LOAD * FROM [lib://QUALIF_2025/01_ABCD_QUALIF_AI.xlsx] (ooxml, embedded labels, table is [My Sheet]) where ORIGINE='RE' OR ORIGINE='AE'

it seem that qlik does not recognise labels when trying to load all files in the same script it the format is xlsx ?

Can someone help me ?

Thanks in advance

Re: Error with load xlsx files , "Field not found"

Lucke_Hallbergson — Wed, 21 May 2025 11:04:32 GMT

If you load files with noconcatenate added (see https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptPrefixes/NoConcatenate.htm) and inspect fieldnames, do you see any difference when looking at the tables in Data Model Viewer?

Another way to pinpoint could be to try to load like this;

FOR EACH vFile IN FileList('lib://QUALIF_2025/??_ABCD_QUALIF_AI.xlsx')
TRACE Loading file: $(vFile);
LOAD * FROM [$(vFile)]
(ooxml, embedded labels, table is [My Sheet]);
NEXT vFile

That would also pinpoint which file is giving you trouble

Re: Error with load xlsx files , "Field not found"

brunobertels — Wed, 21 May 2025 12:03:11 GMT

Hi Lucke

Thanks a lot for your respons. It traced the error in the fourth file.

since april those export are now stored in a google space rather than a windows directory and it seems that it corrupts the output format.

regards

topic Re: Error with load xlsx files , "Field not found" in App Development

Error with load xlsx files , "Field not found"

Re: Error with load xlsx files , "Field not found"

Re: Error with load xlsx files , "Field not found"