topic Re: Conditional Load statement (Checking for table existence while loading) in QlikView

Conditional Load statement (Checking for table existence while loading)

Anonymous — Mon, 15 Jun 2015 16:46:47 GMT

Hi All,

I have a requirement in Qlikview where I need to display the total quarter wise. My approach was to create quarter wise data from the main table (i.e. create separate table for each quarter) and then calculating the total, after which combining the separate quarter tables into a single table. While doing this, qlikview throws an error since my last two quarters data is unavailable and hence the table is empty. Is there any way to check whether table contains data while loading it?

Re: Conditional Load statement (Checking for table existence while loading)

sunny_talwar — Mon, 15 Jun 2015 16:53:50 GMT

Are you trying to check a external file (like a Excel file) to see if it exists or not? or is it during a resident load?

External file can be checked like this:

Set vFile = 'Data\XYZ.qvd'; //Path of the file where you have to check

Let vFileExist = If(FileSize(vFile) > 0, -1, 0); /* Checking if the file exist in the directory. */

IF $(vFileExist) then

....

ENDIF

I hope this helps.

Best,

Sunny

Re: Conditional Load statement (Checking for table existence while loading)

ramoncova06 — Mon, 15 Jun 2015 16:56:29 GMT

you can add a rowno() to the loading table and then check if this is higher than one

Table

load:

field1,

field2,

rowno() as Rowno

from data

if max(Rowno)>= 1 then

whatever goes here

end if

Re: Conditional Load statement (Checking for table existence while loading)

Anonymous — Tue, 16 Jun 2015 06:45:18 GMT

if(NoofRows('Table1')>0)then

//Load

//Resident table1;

Endif

This condition works.

Thanks everyone for you help

Thanks!