Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
JACKNIEKERK
Creator
Creator

filling a list from a text file into Qlikview

I found on a forum wich works ok a way to click in list to show a PDF
Now i added them by hand in the load part of qlikview , one by one , by name
How to get them every time when reloading qlikview , reading a text file wich will contain all these documents name
instead of adding manualy in the loading  part, wich would be not meaningfull

1 Solution

Accepted Solutions
JACKNIEKERK
Creator
Creator
Author

Spoiler
ok after changing in:

for each File in filelist ('K://QLIKVIEW-2019/SUNKIP/*.pdf')
LOAD
'$(_File)' as DocumentLink,
'PDF Document ' & Subfield( '$(_File)' , '/', -1) as DocumentName
autogenerate 1;
next File

to this:

for each File in filelist ('K:/QLIKVIEW-2019/SUNKIP/*.PDF')
LOAD
'K:/QLIKVIEW-2019/SUNKIP/' & '$(File)' as DocumentLink,
Subfield( '$(File)' , '/', -1) as DocumentName
autogenerate 1;
next File

the problem was the  underscore in  '$(_File)'

thanks for startup

regards Jack

View solution in original post

3 Replies
Vegar
MVP
MVP

Try something like this

for each _File in filelist ('K://QLIKVIEW-2019/SUNKIP/*.pdf')
  LOAD
    '$(_File)' as Link,
    'PDF Document ' & Subfield( '$(_File)' , '/', -1) as DocumentName
  autogenerate 1;
next _File

JACKNIEKERK
Creator
Creator
Author

hello , getting close  I think

I have now in Load

DocTable:
//==============
LOAD 'PDF Document ' AS DocumentName, 'K:/QLIKVIEW-2019/SUNKIP/1012.pdf' AS DocumentLink // this thus set fixed
AUTOGENERATE 1;

for each File in filelist ('K://QLIKVIEW-2019/SUNKIP/*.pdf')
LOAD
'$(_File)' as DocumentLink,
'PDF Document ' & Subfield( '$(_File)' , '/', -1) as DocumentName
autogenerate 1;
next File

It should show 4 files wich are there it shows one  but format , I mean as result path is not 

ok, and or working see attched  screen please, so i do something still wrong

please advice

 

JACKNIEKERK
Creator
Creator
Author

Spoiler
ok after changing in:

for each File in filelist ('K://QLIKVIEW-2019/SUNKIP/*.pdf')
LOAD
'$(_File)' as DocumentLink,
'PDF Document ' & Subfield( '$(_File)' , '/', -1) as DocumentName
autogenerate 1;
next File

to this:

for each File in filelist ('K:/QLIKVIEW-2019/SUNKIP/*.PDF')
LOAD
'K:/QLIKVIEW-2019/SUNKIP/' & '$(File)' as DocumentLink,
Subfield( '$(File)' , '/', -1) as DocumentName
autogenerate 1;
next File

the problem was the  underscore in  '$(_File)'

thanks for startup

regards Jack