Conditional load with do while

[tommyl]

Hello,

I am trying to make a loop in the load script, by checking a field's value in a table. I wrote this loop:

SELECT status
FROM [schema].[table];
let vSwitch = fieldvalue('status', 1);

do while ('$(vSwitch)'='false')
sleep 900000;
SELECT status
FROM [schema].[table];
let vSwitch = fieldvalue('status', 1);
exit do when ('$(vSwitch)'='true');

loop ;

But i cannot pass to the exit do part. Could anyone please help me on the problem? 

Regards,

[Kushal_Chawda]

loop seems to be fine. what you are trying to achieve?

[Kushal_Chawda]

or may be checkout this

https://support.qlik.com/articles/000073866

[tommyl]

Hello Kush,

What  i am trying to do is:

During the table creation on hive, if my auto load and hive table creation times collides; i get load error if any of my tables does not exist.

That's  why i read a table with only displaying "True" or "False" values (which shows tables are ready or not). The required steps are:  

1. If the value is "False" i want my script to be "sleep" for a while. 

2. check the table value again, if still "False", sleep again and check again. 

3. Until the table's value turns to "True", continue to do this. If it is "True", i want the load continue with reading the other table's data. 

Deletion of $ didnt work either.

Regards,