topic Re: How to write a Script to load SQL table into Qlikview table? in QlikView

How to write a Script to load SQL table into Qlikview table?

Anonymous — Wed, 08 May 2013 07:04:23 GMT

Hi There,

I need to load all the columns from SQL table into Qlikview table.

Tab1:

SQL

Select *
FROM db

WHERE (col1 IN $(a);

Is the above script is correct? I got an error msg,'Custom read Failed'

Please help me

Re: How to write a Script to load SQL table into Qlikview table?

jagan — Wed, 08 May 2013 07:20:02 GMT

Hi,

Try this script

SQL

Select *
FROM db

WHERE col1 IN $(a);

What value is there in variable a?

Regards,

Jagan.

Re: How to write a Script to load SQL table into Qlikview table?

Wed, 08 May 2013 07:22:03 GMT

Problem with the variable $(a)

rest is correct

Re: How to write a Script to load SQL table into Qlikview table?

Anonymous — Wed, 08 May 2013 07:28:25 GMT

Let us consider the variable has ,

('1234','4567')

Re: How to write a Script to load SQL table into Qlikview table?

Anonymous — Wed, 08 May 2013 07:34:29 GMT

Do we need to use load command or we can directly use SQL select to load the data into Qlikview table?

Tab1:

load * SQL Select *
FROM db

WHERE (col1 IN $(a));

Re: How to write a Script to load SQL table into Qlikview table?

Anonymous — Wed, 08 May 2013 07:49:59 GMT

Got the below error,

Custome Read failed:

Tab1:

SQL Select *

FROM db

WHERE (col1 IN ( '1234', '4567' ))

Re: How to write a Script to load SQL table into Qlikview table?

jagan — Wed, 08 May 2013 13:35:47 GMT

Hi,

Try this script

SQL

Select *
FROM db

WHERE col1 IN ($(a));

Regards,

Jagan.

Re: How to write a Script to load SQL table into Qlikview table?

kaushiknsolanki — Wed, 08 May 2013 13:43:39 GMT

Hi,

Try this.

SQL

Select *
FROM db

WHERE col1 IN $(a);

Regards,

Kaushik Solanki

Re: How to write a Script to load SQL table into Qlikview table?

Wed, 08 May 2013 20:04:40 GMT

May I ask you how you populate the variable "a" ?

what you need to do is, populate the variable with the full string including the '(" & ')'

let a = '('& chr(39) &'1234'& chr(39) &','& chr(39) & '5678'& chr(39) &')';

then do the select as

select * from DB where col1 IN $(a)

I am using this method with my QV app. So it will work

Thanks,

Aji Paul.