Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone - I'm new here so I'd like to say hi to all of You.
We have app that has been created by external company - it uses SAP (Qlik Connector) to gather SAP data and some xls source files.
Data is gathered every 2 hours - apart from I have no idea how these extractors/generators work I want to make some changes to script and test it. Qvw file for main app is ~800 mb - when I make some changes in script and want to test if result is OK (let's say that I add some field or change calculations) do I have to reload data everytime (ctrl+r) and import all of those megabytes?
I know that I can also partial reload but sometimes I need to change somethin in live running app and when I partially reload my users will see only partial data (amirite?)
Please be forgiving to a freshman
Michał
Hi Michal,
The script changes you do will only take effect on the next active reload of the app, either by task on QMC or manual reload (ctrl+r) you do.
For testing effects, you could use the First prefix before the load statement to test with a limited number of rows.
Something like:
First 100
Load:
A,
B
From '(file)';
To load first 100 rows of the '(file)' on the From clause for example.
Felipe.
Hi Michal,
The script changes you do will only take effect on the next active reload of the app, either by task on QMC or manual reload (ctrl+r) you do.
For testing effects, you could use the First prefix before the load statement to test with a limited number of rows.
Something like:
First 100
Load:
A,
B
From '(file)';
To load first 100 rows of the '(file)' on the From clause for example.
Felipe.
I would suggest that don't make any change in live application until its tested. Just take a copy of existing file and play around with that.
Hello, thanks
I have lots and lots of LOAD statements, I assume that I need to put it in every LOAD block?
Regards
M
Hello, thanks.
That's what I've done today, copied app file to my desktop.
I also changed it to use no compression but full reload takes same amount of time, because source files that contains data extracted from sap are compressed too, I guess
Hi Michal,
Depends from where your loading it.
If your loading from multiple files yes, if a single table holds all the data and then you derive the other tables from this one (Resident load) you can only do one.
I guess the fastest way to do it is simply do a find / replace of "load" to "first X load", where x is how many rows you want, something like:
table:
Load
*
From / Resident and so on.
to:
table:
first X load
*
From / Resident and so on.
Felipe.
Thanks
this x can of course be variable too
Rgds
M