Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Kaushik2020
Creator III
Creator III

Calling Procedure in load editor based on system date

Hello Everyone, 

I have a scenario where I have to call Procedure based on system date. below is the scenario.

----------------------------------------------------------------

If system_date =1 (1st of every month)

then sql call procedure_1 and sql procedure 2;

else

sql call procedure_2

--------------------------

how i can achieve this via load editor.

Labels (4)
1 Solution

Accepted Solutions
LRuCelver
Partner - Creator III
Partner - Creator III

 

If Day(Today()) = 1 then
	Trace Procedure 1;
End If

Trace Procedure 2;

 

View solution in original post

1 Reply
LRuCelver
Partner - Creator III
Partner - Creator III

 

If Day(Today()) = 1 then
	Trace Procedure 1;
End If

Trace Procedure 2;