Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Data aggregation & transforming

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

1 Solution

Accepted Solutions
prieper
Honored Contributor II

Data aggregation & transforming

Hi,

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

/Peter

3 Replies
prieper
Honored Contributor II

Data aggregation & transforming

Hi,

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

/Peter

MVP & Luminary
MVP & Luminary

Data aggregation & transforming

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

Not applicable

Data aggregation & transforming

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