topic Re: Excel File as join table in PC and Server in QlikView

Excel File as join table in PC and Server

Anonymous — Fri, 11 Sep 2015 20:58:43 GMT

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.

Re: Excel File as join table in PC and Server

Oleg_Troyansky — Fri, 11 Sep 2015 21:14:56 GMT

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

Re: Excel File as join table in PC and Server

Anonymous — Fri, 11 Sep 2015 21:27:05 GMT

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.

Re: Excel File as join table in PC and Server

Oleg_Troyansky — Fri, 11 Sep 2015 21:49:58 GMT

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.