Discussion Board for collaboration related to Creating Analytics for QlikView.
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?
Go to Solution.
certainly you can do. Please check the OL-Help for LOAD-syntax.
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.
Thanks for assisance, Ralf. Concat function suites me well.