Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello experts,
I wanted to know if Qlikview supports unstructured data like log files, web logs.
If you want to know if you can read in text files, yes you can.
You also can use a lot of different string functions (have a look at the help file (search for string functions) for all details) to parse the text files into fields.
Does this answer your question? If not, please give a little more information about your needs.
Regards,
Stefan
If you want to know if you can read in text files, yes you can.
You also can use a lot of different string functions (have a look at the help file (search for string functions) for all details) to parse the text files into fields.
Does this answer your question? If not, please give a little more information about your needs.
Regards,
Stefan
Hi Swuehl,
Could you please elaborate.
Not text files, actual web logs.
Regards,
Viraj
Hm, not sure what I should elaborate on...
What do you mean with web logs, something like
http://en.wikipedia.org/wiki/Blog?
You can load html tables from web sources (e.g.tables from wikipedia), using an url in the FROM part, like
LOAD Rank,
Country,
[Birth rate (births per year per 1000 persons)]
FROM
[http://en.wikipedia.org/wiki/List_of_countries_by_birth_rate]
(html, codepage is 1252, embedded labels, table is @1);
If mean loading weg site access logs, those are usually csv files, and yes they can be procedded easily by Qlikview.
-Rob
For example, I want to pick data from facebook/twitter. . .
Can i do that?
Regards,
Viraj
Search for QVSource here in the forum and the Web.
It's connecting some of the most popular social communities APIs to QV.
It is a commercial 3rd party product and maybe there are also some competitors.
Just search the Web for QV connectors.
Look at Qlikview Partner Attivio. They allow you to pull Structured and Unstructured from virtually any source and visualize it through Qlikview. They have a demo up on QlikMarket.