IF field = True THEN load script?

[greend21]

I want an to use an IF statement in my load script that checks if our database load is done before Qlik runs a loader. I have the SQL query check if the load is done and return true for [LoadComplete]. I then had my IF as  IF(LoadComplete = 'True') THEN followed by my load script. LoadComplete can only have one value and it must be true or false. Any ideas on how I can get this to work? I also tried IF(Peek(LoadComplete) = 'True') THEN.

[swuehl · Accepted solution]

How does your script look like?

edit:

Maybe like this

// Script to load field LoadComplete into table Check

...

//

Let vCheck = Peek('LoadComplete',0,'Check');

TRACE $(vCheck);

IF vCheck = 'True' THEN

// other LOAD statements

ENDIF   

[ahmar811]

try

Qlikview ScriptError variable also find below link for more details and examples.

https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Scripting/ErrorVariables...

Regards

Ahmar