jack niekerk
asked on
Inserting in Qlikview from a directory all *.pdf or *.doc files into a object , click a file and open it
i got this sofar
for each File in filelist ('V:/1 KWALITEIT/Organisatie Sunkip/Certificaten Sunkip/HACCP & QS Certificaten Sunkip/*.*')
LOAD
'V:/1 KWALITEIT/Organisatie Sunkip/Certificaten Sunkip/HACCP & QS Certificaten Sunkip/' & '$(File)' as DocumentLink100,
Subfield( '$(File)' , '/', -1) as DocumentName100
autogenerate 100;
next File
this in Graphic object , works ok line click opens file
problem since all files moved to other directory, work not anymore
'NEW VERSION
for each File in filelist ('I:/1 KWALITEIT-2020/Organisatie Sunkip/Certificaten Sunkip/HACCP & QS Certificaten Sunkip/*.*')
LOAD
'I:/1 KWALITEIT-2020/Organisatie Sunkip/Certificaten Sunkip/HACCP & QS Certificaten Sunkip/' & '$(File)' as DocumentLink100,
Subfield( '$(File)' , '/', -1) as DocumentName100
autogenerate 100;
next File
have to change more the 1000 files definitions, in edit do a find change ,
So looking for OR a better solution in code also due have to make for each directory hardcoding in source also
if new directories arise
OR to get solution to make this one stable
for each File in filelist ('V:/1 KWALITEIT/Organisatie Sunkip/Certificaten Sunkip/HACCP & QS Certificaten Sunkip/*.*')
LOAD
'V:/1 KWALITEIT/Organisatie Sunkip/Certificaten Sunkip/HACCP & QS Certificaten Sunkip/' & '$(File)' as DocumentLink100,
Subfield( '$(File)' , '/', -1) as DocumentName100
autogenerate 100;
next File
this in Graphic object , works ok line click opens file
problem since all files moved to other directory, work not anymore
'NEW VERSION
for each File in filelist ('I:/1 KWALITEIT-2020/Organisatie
LOAD
'I:/1 KWALITEIT-2020/Organisatie
Subfield( '$(File)' , '/', -1) as DocumentName100
autogenerate 100;
next File
have to change more the 1000 files definitions, in edit do a find change ,
So looking for OR a better solution in code also due have to make for each directory hardcoding in source also
if new directories arise
OR to get solution to make this one stable
This question needs an answer!
Become an EE member today
7 DAY FREE TRIALMembers can start a 7-Day Free trial then enjoy unlimited access to the platform.
View membership options
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
ASKER