Error in loading data

[#1]

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

[swuehl]

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?

[#3]

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 ?

[swuehl]

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?

[#5]

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?

[swuehl]

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?