The target of this script is to have a list of images indexed in qlikview to load in a chart:
for each File in filelist ('\\path\directory\*');
IMAGE_TABLE:
add load distinct
purgechar(purgechar(left('$(File)',6),'.-'),chr(39)) as INVN_SBS_DESCRIPTION1,
'$(File)' as INVN_SBS_IMAGE,
autonumber('$(File)') as AUTO_INDEX;
next File
store * from IMAGE_TABLE into IMAGE_TABLE.qvd;
drop table IMAGE_TABLE; Has anybody noticed differences with using:
IMAGE_TABLE:
add load distinct
purgechar(purgechar(left(filename(),6),'.-'),chr(39)) as INVN_SBS_DESCRIPTION1,
'filename()' as INVN_SBS_IMAGE,
autonumber('filename()') as AUTO_INDEX
from \\path\directory\*;
store * from IMAGE_TABLE into IMAGE_TABLE.qvd;
drop table IMAGE_TABLE;
Thanks!!
P.S.: the directory I'm reading in has 35k files and growing, the second statement runs in 2-3 hours depending on the LAN saturation, the first one I'm testing now but I haven't noticed differences yet...
