Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Have you tried this?
Table1:
Add Load column1, *;
SQL EXEC dbo.SampleProcedure @CompaignName = 'sampleData';
i've tried just right now, but unfortunately not working
OLEDB read failed