topic Working in SQL but not while loading the data into qlikview in QlikView

Working in SQL but not while loading the data into qlikview

Thu, 13 May 2010 13:34:02 GMT

Hi All,

Below query works in the sql and able to fetch the data. But when i try to load the data it is giving the error message which is there below. May I know the reason for that?


select * from user_request us join menu_list menu on menu.n_menuid=us.n_menu_id where us.n_flag=3

Working in SQL but not while loading the data into qlikview

Thu, 13 May 2010 13:40:00 GMT

Hi,

You can try change the sql for this. I have the same problem.


select
 *
from
 user_request us,
 menu_list menu
where menu.n_menuid=us.n_menu_id
 and us.n_flag=3

Regards.
Tonial.

Working in SQL but not while loading the data into qlikview

Thu, 13 May 2010 13:45:52 GMT

Hi Tonial,

Thanks! But it doesn't work either!

Working in SQL but not while loading the data into qlikview

sparur — Thu, 13 May 2010 13:45:56 GMT

Hello,

or try to correct your sql query:

select * from user_request us join menu_list menu on menu.n_menuid=us.n_menu_id where us.n_flag='3'

Working in SQL but not while loading the data into qlikview

Thu, 13 May 2010 13:48:20 GMT


sparur wrote:
try to correct your sql query:
select * from user_request us join menu_list menu on menu.n_menuid=us.n_menu_id where us.n_flag='3'<div></div>

Tried with also but it is not working

Working in SQL but not while loading the data into qlikview

Anonymous — Thu, 13 May 2010 15:12:09 GMT

I had same issue a few days ago, it looks like you need to define your column names in your SQL.

Working in SQL but not while loading the data into qlikview

Tue, 23 Nov 2010 15:35:08 GMT

I had this same type of issue and after another look at the SQL statement I was using, I noticed I had more than one column defined with the same name. It does not like this. After I got rid of the duplicate column it ran fine.