topic Data aggregation & transforming in QlikView

Data aggregation & transforming

Mon, 04 May 2009 17:46:07 GMT

Hi all,

I'm new to Qlik, now only trying to load some data from external sources. Could someone tell me if I can transfrom data uploaded by SQL SELECT command?

I mean that I have a list of values and I want to group them via text likeness (like 'ABC%' thing in SQL). Frankly, I want such a thing - "value, group_1, group_2" instead of my value table.

I just can't get what function should I use?

Or maybe I should start with making variables?

WBR,

Mikhail

Data aggregation & transforming

prieper — Mon, 04 May 2009 17:55:50 GMT

Hi,

certainly you can do. Please check the OL-Help for LOAD-syntax.

/Peter

Data aggregation & transforming

rbecher — Mon, 04 May 2009 18:45:25 GMT

Mikhail,

if I read it right, you could use aggregation function concat and group by value in a LOAD command:

LOAD value, concat(<field>, ', ') AS field_list FROM <table> GROUP BY value;

But, iff this meets your approach I rather would suggest to use a different data model like star schema.

Ralf

Data aggregation & transforming

Mon, 04 May 2009 18:50:50 GMT

Thanks for assisance, Ralf. Concat function suites me well.