topic Re: How to fill data(data stuffing) in file while loading qlikview application? in QlikView

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

ysj — Wed, 25 Nov 2020 16:16:04 GMT

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,

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

omkarvamsi — Wed, 16 Aug 2017 14:28:23 GMT

you can try

SET Errormode=0;

write the SET statement in the script starting position and reload the script.you will not see the file not found error.

please explain this " adding data for missing log file"

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

ysj — Thu, 17 Aug 2017 09:25:16 GMT

Thank you Omkar,

I know we can write SET Errormode=0; it will not give any error but I dont want this.

Suppose one of the file is missing then it should be NA or Unkown .

Example: Suppose I want load 4 files in my dashboard so i have pass the value as 4 i.e 0 to 3 to variable to read the four days of data but i have only three files what shall I do in this case.

Please suggest you thoughts.

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

Anil_Babu_Samineni — Thu, 17 Aug 2017 09:29:06 GMT

Can you explain real data of log files where you do? Do you getting this using For ... Loop ???

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

ysj — Thu, 17 Aug 2017 09:33:24 GMT

Hi Anil,

I have different log files like session log, event log,performance log now what happen when I am using single for loop for all log files to fetch data then suppose event has all files same for performance but one of session file is not created then what to do in such scenario.

For that what I am doing I am fetching data but its not working

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

Anonymous — Thu, 17 Aug 2017 09:33:38 GMT

for the critical parts, you should Set ErrorMode = 0 and then Set it back to 1.

Within the critical parts you will have to implement a kind of errorhandling.

You can read the variables ScriptError and ScriptErrorDetails for further information which error occurred.

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

Anil_Babu_Samineni — Thu, 17 Aug 2017 09:35:23 GMT

Rather function can be possible using technical. May be we can restrict with in the For..Loop. using other functionality. Can you share the code?

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

ysj — Thu, 17 Aug 2017 09:44:13 GMT

Hi Anil,

I cant share you file as its sensitive information as well.

Could you please help me for those file that does not have data .i.e that file is not present in source its self then what to do without failing error script

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

Anil_Babu_Samineni — Thu, 17 Aug 2017 09:59:30 GMT

Qlik Community Tip: How to Get Answers to Your Post

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

ysj — Thu, 17 Aug 2017 10:21:00 GMT

Please find attached application to main thread.

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

omkarvamsi — Fri, 18 Aug 2017 08:51:37 GMT

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?

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

ysj — Fri, 18 Aug 2017 09:20:39 GMT

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

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

omkarvamsi — Fri, 18 Aug 2017 10:32:15 GMT

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