topic Re: Load text files from a folder and create source file field in QlikView

Load text files from a folder and create source file field

moorematthewj — Sat, 16 Nov 2024 19:59:02 GMT

I'm loading multiple text files from a folder. Each text file is named different.

I want to create a field within the load script that will identify each text file based on the name of the text file. I'm discovering corrupt data within the source files. I need something that will help me filter and zero in on the problems without having to load each text file separately and creating a field that way.

my load script starts with this:

SUB DoDir (Root)

FOR each File in filelist(Root& '\*.txt')

Any thoughts or tips?

Re: Load text files from a folder and create source file field

StarinieriG — Wed, 02 Oct 2019 08:12:37 GMT

Hi,

you could create a field inside the load using FileName()

Re: Load text files from a folder and create source file field

moorematthewj — Wed, 02 Oct 2019 11:51:52 GMT

Worked perfectly! Thanks for the help.