topic Unstructured data and qlikview in QlikView

Unstructured data and qlikview

Wed, 24 Aug 2011 21:28:13 GMT

Hello experts,

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

Unstructured data and qlikview

swuehl — Wed, 24 Aug 2011 22:09:57 GMT

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

Unstructured data and qlikview

Mon, 07 May 2012 06:04:34 GMT

Hi Swuehl,

Could you please elaborate.

Not text files, actual web logs.

Regards,

Viraj

Unstructured data and qlikview

swuehl — Mon, 07 May 2012 18:08:59 GMT

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

Unstructured data and qlikview

rwunderlich — Mon, 07 May 2012 22:54:11 GMT

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

-Rob

Unstructured data and qlikview

Wed, 09 May 2012 06:57:18 GMT

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

Can i do that?

Regards,

Viraj

Unstructured data and qlikview

swuehl — Wed, 09 May 2012 07:14:19 GMT

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.

Unstructured data and qlikview

Thu, 31 May 2012 18:55:14 GMT

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.