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: 
ysj
Creator
Creator

How to fill data(data stuffing) in file while loading qlikview application?

Hi,

I have data of log file for month but what I have observed that some of the log files are missing then at the time of reloading its giving an error that file not found.

Want to achieve: Load the application without error and adding data for missing log file.

Could you please suggest the way.

Thank you,

YJ

12 Replies
omkarvamsi
Creator
Creator

for the conversation what i understand is....

1.you want to load 4 files like sessions,events,file 3,file 4....etc

2.for example,the session file is missing.now you want to show the value as "session file not loaded"

is that it?

ysj
Creator
Creator
Author

Hi Omkar,

Suppose I want to load files like

Events_ABCD_2017-08-15.log  ,

Events_ABCD_2017-08-16.log  ,

Events_ABCD_2017-08-17.log  ,

Events_ABCD_2017-08-18.log


Now what happens while loading the data one file is not present in source from where I am fetching then what sahll i do. I want to load document without any error

omkarvamsi
Creator
Creator

You can load the file using below script

Load

    *

from Events_ABCD_*.log;

now qlikview will load the files which are named with the prefix Events_ABCD_;

you can text me on +91 9676861816