topic Loading with * from Stored Procedure in QlikView

Loading with * from Stored Procedure

Thu, 22 Jan 2015 14:45:52 GMT

i have a stored procedure on sql.

I am calling the procedure.

But there are about 100 columns of result.

so i want to load thoose results with * char.

The qlikview script code is like below:

Table1:
Add Load *;
SQL EXEC dbo.SampleProcedure @CompaignName = 'sampleData';

it doesnt load by this way.

but when i write:

Table1:
Add Load column1;
SQL EXEC dbo.SampleProcedure @CompaignName = 'sampleData';

it loads to data.

The thing is i just don't want to write all of thoose columns.

Thanx

Anonymous — Thu, 22 Jan 2015 15:47:59 GMT

Have you tried this?

Table1:

Add Load column1, *;

SQL EXEC dbo.SampleProcedure @CompaignName = 'sampleData';

Thu, 22 Jan 2015 15:56:02 GMT

i've tried just right now, but unfortunately not working

OLEDB read failed