Link to home
Start Free TrialLog in
Avatar of jack niekerk
jack niekerkFlag for Netherlands

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 ariseUser generated image
OR to get solution to make this one stable

User generated image
Avatar of jack niekerk
jack niekerk
Flag of Netherlands image

ASKER

it is needed for Qlikview  NOT Sence,  but can't  add topic for Qlikview version
This question needs an answer!
Become an EE member today
7 DAY FREE TRIAL
Members 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.