Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi community,
I got a stored procedure that I want to Execute and store into a CSV file.
The Stored procedure has 3 variables: StartDate, StopDate, AccountId.
Is it possible to enter these 3 variables and then Execute: GenerateFile - "stored procedure"?
csv:
SQL EXEC GenerateCommciseFile
@startDate = '$(vL.startDate)',
@endDate = '$(vL.startDate)',
@accountId = null
;
STORE * FROM csv into test.csv (txt, delimiter is ',');
Might be the following link can help:
Hi Niklas
It is possible to execute a store procedure in qlikview, see this link to help you
SQL Stored Procedure into QlikView
https://community.qlik.com/thread/68950
You have to call the procedure and pass the parameters(values)
SQL EXEC MYPROCEDURE('VAL1','VAL2', 'VAL3')
csv:
SQL EXEC GenerateCommciseFile
@startDate = '$(vL.startDate)',
@endDate = '$(vL.startDate)',
@accountId = null
;
STORE * FROM csv into test.csv (txt, delimiter is ',');