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...
