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

[Anonymous]

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

[jagan]

Hi,

Try this script

SQL

Select *
FROM db

WHERE col1 IN $(a);

What value is there in variable a?

Regards,

Jagan.

[#3]

Problem with the variable $(a)

rest is correct

[Anonymous]

Let us consider the variable has ,

('1234','4567')

[Anonymous]

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));

[Anonymous]

Got the below error,

Custome Read failed:

Tab1:

SQL Select *

FROM db

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

[jagan]

Hi,

Try this script

SQL

Select *
FROM db

WHERE col1 IN ($(a));

Regards,

Jagan.

[kaushiknsolanki]

Hi,

     Try this.

SQL

Select *
FROM db

WHERE col1 IN $(a);

Regards,

Kaushik Solanki

[#9]

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.