topic Giving Error for Simple Join statment in QlikView

Giving Error for Simple Join statment

Thu, 14 Apr 2011 10:42:30 GMT

Hi all,

I have Qlikview Version 10.00.8811.6 SR1. when i try to join two simple tables, it gives an error like.. Execution failing error. why i dont know.

here the code, what i am getting error.

Tab:

Load No,

Name

From Excel111.xls;

join

Load No,

Sal

From Excel222.xls;

Please some one help me.. Thanks in advance..

Giving Error for Simple Join statment

Miguel_Angel_Baeyens — Thu, 14 Apr 2011 10:49:02 GMT

Hello Arun,

Have you tried using QVD or INLINE tables?

Table1:LOAD * INLINE [No, Name1, AAA2, BBB]; Table2:JOIN LOAD * INLINE [No, Sal1, 100002, 20000];

The code doesn't seem to be wrong, at least not that piece of code.

Are you doing that in a new document only with those two tables?

Hope that helps.

Giving Error for Simple Join statment

Thu, 14 Apr 2011 10:58:15 GMT

Hi Miguel Angel ,

Thanks for your reply...

i have QV 9.0 also. on that this same code was working fine.. but when i execute the same code in QV 10, its giving Error "Execution of Script Failed". i think my QV10 is not supporting joins. i have tried on Qvds also. i think it was not installed properly, otherwise in QV10, are there any other features for joins the tables. From last two days am facing this. i got a doubt also like, is QV10 supports JOINs?

please break my doubt.... thank u

Giving Error for Simple Join statment

Thu, 14 Apr 2011 11:06:13 GMT

Hi Miguel Angel

Your code is working fine on my QV10. please tell me, final result stores into Table1 or into Table2. If i join three tables how can i write..?

thanks..

Giving Error for Simple Join statment

Miguel_Angel_Baeyens — Thu, 14 Apr 2011 11:24:56 GMT

Hello Arun,

The result of a join will be always one table with the label of this first table (the one not preceding by "JOIN". Actually, label in following tables is not needed, and may make no sense, and rather you may use a comment line in any case.

If you want to join a third table, just make sure this third table as a field name in common with the previous one (that now consists of Table1 and Table2, so any of their records will do).

Table1:LOAD * INLINE [No, Name1, AAA2, BBB];Table2:JOIN LOAD * INLINE [No, Sal1, 100002, 20000]; Table3:JOIN LOAD * INLINE [Name, CustAAA, ZZZZBBB, YYYY];

Now the result is one table "Table1" with all four fields.

Hope that helps.

Giving Error for Simple Join statment

erichshiino — Thu, 14 Apr 2011 18:52:31 GMT

Arun, in your code you didn't mention excel spreadsheets inside the .xls

Maybe QlikView is handling this in a different way in v10.

I hope this can help isolate the problem.

Rgds,

Erich