Trying to load missing data

Thu, 28 Jul 2011 11:04:37 GMT

Hi,

I am new to QlikView and I'm trying to create a QlikView document to store and manage data. I have several reports produced by the same program, but out of a list of about 30 fields the various reports may contain any 20 of these.

The code I am using is:

PolicyData:
LOAD '$(varRunDate)' as RunDate,
'$(varCompany)' as Company,
'$(varProduct)' as Product,
CALENDAR_YR,
GROSS_PROFIT,
NET_PROFIT
FROM
$(varFilePath).prn
;

Store PolicyData into ;

PolicyData:
LOAD * FROM

(qvd);

So I load in the new report, save it in a data folder, then load in all saved reports. As I load in all saved reports after every update I want all the data to be saved with identical columns, but some reports will contain GROSS_PROFIT and not NET_PROFIT, and vice versa. In reality there are more like 30 fields of which the report may contain any 20.

When I first load in the report is there any way to give a field a default value of 0 if it is not present in the report?

Thanks in advance for any help.

Trying to load missing data

Thu, 28 Jul 2011 14:00:08 GMT

bump

Trying to load missing data

Anonymous — Fri, 19 Aug 2011 06:23:11 GMT

first try loading all the field names seperately... and then check if the field is nul.. and if its null.. or its not there.. then assign anything in place of that field... like using a for loop...

hope this helps..

topic Trying to load missing data in QlikView

Trying to load missing data

Trying to load missing data

Trying to load missing data