topic Re: DataBase table count in QlikView

DataBase table count

Thu, 05 Feb 2015 02:39:04 GMT

Hi all,

I have a tricky requirement.

I am extracting a table from DB and storing into QVD. (works fine till now)

when the table crashes in DB and qvw reloads then we will get zero records . Is there any way if the table crashes/deleted the dashboad should get the previous records?

Hope to get some solutions and pls share sample app

Re: DataBase table count

jagan — Thu, 05 Feb 2015 03:43:44 GMT

Hi,

Try this script

TableName:

LOAD

FROM DataSource;

If NoOfRows('TableName') > 0 THEN

STORE TableName INTO QVDFileName.qvd;

END IF;

Hope this helps you.

Regards,

Jagan.

Re: DataBase table count

Thu, 05 Feb 2015 03:46:07 GMT

Thanks Jagan

what if table is empty then the qvd should store the old data

could you specify this logic pls

Re: DataBase table count

jagan — Thu, 05 Feb 2015 03:55:41 GMT

Hi,

If the table is empty we are not updating the QVD with the empty table, so you will get the old data from QVD since is not replaced with the latest one.

Regards,

Jagan.

Re: DataBase table count

Thu, 05 Feb 2015 07:20:24 GMT

Thanks jagan

hope to see you back