This content has been marked as final. Show 7 replies
I would like to know whether we can set a field after each document load. Let me explain the scenario in detail below:
I have a set of files in a folder like file1.txt, file2.txt, file3.txt, etc.,
I will be loading these files to the Qlikview like:
Load * from file*.txt;
Now I need to add a field to add the file name that I m loading.
My output should be like,
field1 field2 field3
x 2 file1
y 45 file1
z 8 file2
a 8 file3
I need field, field3 which will be added dynamically.
Or is there any other way to set a value to check end of file and use that in an another load statement.
Thanks in Advance