Excel File as join table in PC and Server

[Anonymous]

Hello!

I tried to join an excel file from  my table....However, the joined fields are showing blanks if run it to our server. .  But , it work successfully if I run it on my PC with the same directory as the server.

what's wrong joining  excel file using the server?  Btw, I have one another excel file that I joined in a separate dashboard and it works fine in server.

Pls. advise.

Tks.

[Oleg_Troyansky]

I doubt if the problem is related to JOIN... Since the same logic works successfully on your local PC, but fails on the server, I suspect that this is a security issue. The service account that runs the jobs on the server, may not have access to your Excel file, or to the folder where the Excel file is located.

Another possible issue is the path to your Excel file. You should use either a relative path or a universal UNC address, but not an absolute path that uses your drive letters, like:

C:\QlikView Projects\...

This kind of a path will not work on your server.

So, check these two things - the path (more probable cause) and the security rights for the service account.

cheers,

Oleg Troyansky

QlikView Your Business: An expert guide to Business Discovery with QlikView and Qlik Sense

[Anonymous]

Hi!  Oleg,

Thank you for the prompt response...

I don't think  the issue is the security, 'coz it was able to join to some of the fields except for the one  where 2  fields has TBD...Does it has to do with it ?

Btw, my path is

[C:\QlikviewDocs\ *

Tks.

[Oleg_Troyansky · Accepted solution]

As I said, this kind of path (beginning with C:\...) is not likely to work in the server environment. Try replacing your path with the relative path.