Data aggregation & transforming

[#1]

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

[prieper · Accepted solution]

Hi,

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

/Peter

[rbecher]

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

[#4]

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