This content has been marked as final. Show 6 replies
I need to load a bunch of .csv files that are located on an internet resource. I know I can load them with this simall peace of code:
LOAD id, test1, test2 FROM [http://www.rpostma.com/qvtestt/qvtest.csv] (txt, codepage is 1252, embedded labels, delimiter is ';', msq);
My question is, how I can load exactly this same test-file from a password-protected location.
Load that does NOT work
LOAD id, test1, test2 FROM [http://www.rpostma.com/qvtest/qvtest.csv] (txt, codepage is 1252, embedded labels, delimiter is ';', msq);
As visible in my test-code, I prepared a testfile in 2 different folders (qvtestt (working) and qvtest, not working).
When these below mentioned links are opened in a webbrowser, the 2nd (and NOT working) URL requires a password.
My questions are these
- [Question 1]: Can the load-script be modified to include the username/password?
- [Question 2]: If not, what would be the best way to load these files into Qlikview (perhaps via a Macro? Or another approach? And in that case, could you give a working example for how it works?
The username / password for the password-protected url is:
- user name: qvtest
- password: qvtest
I'm curious about what's possible. Thanks in advance for your contributions!