Random Trigger check and store the File

balrammahato204 — Wed, 25 Nov 2020 16:16:04 GMT

Hi Team,

I have one scenario to achieve please help.

I have three EDX trigger which are coming randomly and my job is triggering as per EdX trigger. Now i wanted to check if all three triggers are came and then in my script i have to concatenate three tables. These three tables are dependent upon the trigger. Means whenever i am getting the trigger corresponding table is update and same table i am pulling inside my script from the database.

My challenge is how can i know all three triggers are came and my data concatenation will happen.

from the Trigger timestamp i can identify the which trigger is latest trigger, But at last not able to decide how all trigger is came.

from the below code i am able to identify the trigger is came and corresponding table data is loaded using corresponding flag, But on completion of all three i have to store the concat QVD and here triggers are not sequential any trigger can come anytime.

Please help or let me know if required more explanation.

Let A_Trigger= Filetime('............\QVW\A_Trigger.txt');

IF('$(A_Trigger)'>'$(vPrevTrigger )') Then
Let vFlagTime='True';
ELSE
Let vFlagTime='False';

ENDif;

Let vPrevTrigger = '$(A_Trigger)';

Let B_Trigger= Filetime('............\QVW\B_Trigger.txt');

IF('$(B_Trigger)'>'$(vPrevTriggerB )') Then
Let vFlagTimeB='True';
ELSE
Let vFlagTimeB='False';

ENDif;

Let vPrevTriggerB = '$(B_Trigger)';

Let C_Trigger= Filetime('............\QVW\C_Trigger.txt');

IF('$(C_Trigger)'>'$(vPrevTriggerC )') Then
Let vFlagTimeC='True';
ELSE
Let vFlagTimeC='False';

ENDif;

Let vPrevTrigger C= '$(C_Trigger)';

Regards

Balram

Re: Random Trigger check and store the File

Brett_Bleess — Tue, 03 Sep 2019 20:11:42 GMT

Best I have is the following:

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/QMC/Content/QV_QMC/QMC_Documents_SourceDocuments_Wizard_TriggerTask.htm#On_multiple_events_completed

I am guessing you want to do this in the script though, not through a separate task, if that is the case, someone else will have to chime in, as I am not sure if that is going to be possible or not.

Regards,
Brett

topic Random Trigger check and store the File in QlikView

Random Trigger check and store the File

Re: Random Trigger check and store the File