Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Unstructured data and qlikview

Hello experts,

   I wanted to know if Qlikview supports unstructured data like log files, web logs.

1 Solution

Accepted Solutions
swuehl
MVP
MVP

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

View solution in original post

7 Replies
swuehl
MVP
MVP

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

Not applicable
Author

Hi Swuehl,

Could you please elaborate.

Not text files, actual web logs.

Regards,

Viraj

swuehl
MVP
MVP

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);

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

If mean loading weg site access logs, those are usually csv files, and yes they can be procedded easily by Qlikview.

-Rob

Not applicable
Author

For example, I want to pick data from facebook/twitter. . .

Can i do that?

Regards,

Viraj

swuehl
MVP
MVP

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.

Not applicable
Author

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.