topic Re: Error in loading data in QlikView

Error in loading data

Wed, 25 Nov 2020 16:16:04 GMT

Hello Everyone,

I am really new to Qlikview and I don't know much about its programming.

I am getting an error when I try to load a file and I would appreciate your help

This is the error I am getting:

Impossible d'ouvrir le fichier'H:\DXA Commun\_ENVIRONNEMENT\2016\E_20 - 2016.xlsx' Le chemin d’accès spécifié est introuvable.

E20:

Load

Autonumber(RecNo()+6) as E20_NUM,

Upper(A) as E20_Statut,

B as E20_ClientE20,

D as E20_ClientNOM,

If(Len(Trim(C))=0, '4' & Right('XXXXXX' & Num(RecNo()+6, '0000'), 6), Trim(C)) as E20_CodeProjetE20,

E as E20_Projet,

F as E20_Autorisé,

If(Len(G)=1,'Voy') & if(len(G&H)>1,'/') & if(Len(H)=1,'TM') as E20_VoyTM,

I as E20_ControlesRecu,

Upper(L) as E20_ControleNonRequis

From (ooxml, no labels, header is 5 lines, table is [E-20])

Where Len(KeepChar(A, '*atgrpc')) > 0 and Len(KeepChar(A, '_')) = 0 and Trim(Upper(A)) <> 'TOTAL'

I can send the E-20 - 2016.xlsx if someone can help me please

Je parle aussi français, donc ce que je voulais dire c'est que quand j'essaye de loader un fichier de qvw ça m,envoie l'erreure précedente et que je peux vous envoyer le fichier excel E_20 - 2016.xlsx si quelqu'un peut m'aider

Merci beaucoup !

Thank you very much

Re: Error in loading data

swuehl — Thu, 12 May 2016 21:44:06 GMT

You've posted this to a QlikSense forum, but you are using QlikView, right?

Have you tried opening the file with the script table wizard?

Re: Error in loading data

Thu, 12 May 2016 22:34:01 GMT

Yes I use Qlikview and I didn't try the script table wizard ! I don't even know what is it !!

By the way the .qvw was working before but today it stopped working. And I don't think that the problem is in the qvw file but in the excel file because thats where we put data !! The qvw file is only gattering data and reorganizing it !! What do you think ?

Re: Error in loading data

swuehl — Thu, 12 May 2016 22:40:51 GMT

Well, that's hard to tell without knowing your setting.

As a first step, I woulld try to open the file using the table wizard. Does this work?

Re: Error in loading data

Thu, 12 May 2016 22:47:49 GMT

I can send you the qvw file tomorrow and the excel file too. Can you tell me what the error I recieve is meaning please?

Re: Error in loading data

swuehl — Fri, 13 May 2016 13:39:13 GMT

I believe the error message is telling you that the excel document can't be found using the specified path.

Are you sure that the H: drive is accessible from the location and using the user your are using to execute your script?