Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am new to QlikView. I am trying to get data from stored procedure.
While it is working for the script using select statement, it is giving Field not found - <A> error message when I am calling the stored procedure. Please can someone help me to proceed with this.
Working script:
LOAD A,B;
SQL SELECT A, B FROM test
Script that is giving error:
LOAD SELECT A, B FROM testA,B;
SQL EXEC
QlikView_Test_Sample; The corresponding Stored procedure:end
Thanks in advance
CREATE procedure QlikView_Test_Sample
AS
begin
It looks like you mis-pasted your code in your post, making it difficult to understand. If you fix it, you may get some responses. I hope so, because I have a very similar problem!
it's tricky when you copy code from specialized Code editors (including QlikView Script Editor... Try to paste your code into Notepad and then copy it and baste it into the forum post...