autogenerate(0)

[TomBond77]

Hi experts

I have a problem with the following code, no records are generated also the source files contain data.  Can you please help? Many thanks!

for each vMergeTable in 'table1', 'table2', 'table3', 'table4'

$(vMergeTable):
LOAD 1 as Sourcesystem
autogenerate(0);

if FileSize([lib://folder_100/$(vMergeTable).qvd])>0 then
concatenate ($(vMergeTable))
LOAD
*,
'SAP' as Sourcesystem
FROM
[lib://folder_100/$(vMergeTable).qvd](qvd);
end if;

if FileSize([lib://folder_200/$(vMergeTable).qvd])>0 then
concatenate ($(vMergeTable))
LOAD
*,
'Excel' as Sourcesystem
FROM
[lib://folder_200/$(vMergeTable).qvd](qvd);
end if;

store $(vMergeTable) into [lib://folder_300/$(vMergeTable).qvd] (qvd);

[rwunderlich · Accepted solution]

I believe you need single quotes rather than square brackets around your FileSize parameter.

if FileSize('lib://folder_100/$(vMergeTable).qvd')>0 then

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com

[TomBond77]

Thank you very much!