Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Everyone,
I need your help.
I have this Qlikview script to call SQL Stored procedure:
SQL EXEC [dbo].[usp_TimeLogs] '7/1/2017','7/31/2017'
Inside this contains columns like:
Active - which consists of '0' for not active and '1' for active
Timelogs - Duration of People
I need to manipulate columns or create another table from the generated by SQL Stored Procedure.
How can I do that on Qlikview script?
For example:
If Active == 1 then Timelogs
Else NULL
Thanks in advance!
You could possibly try using preceding load like:
Load
If( Active=1, Active) as Timelogs ;
<Your sql procedure facing command here>
You could possibly try using preceding load like:
Load
If( Active=1, Active) as Timelogs ;
<Your sql procedure facing command here>
Are you saying like this?
Load
If( Active=1, Active) as Timelogs ;
SQL EXEC [dbo].[usp_TimeLogs] '7/1/2017','7/31/2017'
If the procedure execution alone gives the data in qlik, that should work.
Yup It works! but I only got the 'Timelogs' column after the load.
You have to include the other fields in load explicitly or '*' for all, like:
Load
*,
If( Active=1, Active) as Timelogs ;
SQL EXEC [dbo].[usp_TimeLogs] '7/1/2017','7/31/2017
Thanks it works!