topic Re: Concat() not working in the script in QlikView

Concat() not working in the script

Mon, 17 Jun 2013 06:35:20 GMT

Hi all,

I have a small table with one column and about ten values that I want to concatenate into a single string in the script:

SQL SELECT DISTINCT item FROM table...;

LET itemString = Concat(item, ',');

However the resulting variable is empty (actually I do not even see it when looking at the variable editor).

When I define the variable in the variable editor (as = Concat(item, ',')), it works fine and I get a concatenated list of all values in the table.

Why is it not working in the script? Is there any other way to achieve this?

Thanks in advance.

Regards,

Robert

Re: Concat() not working in the script

ariel_klien — Mon, 17 Jun 2013 06:47:46 GMT

Try

LET itemString = Concat(peek(ITEM), ',');

Ariel

Re: Concat() not working in the script

Mon, 17 Jun 2013 06:49:34 GMT

Simply use '&' symbol for concat.

Karthik

Re: Concat() not working in the script

kumarnatarajan — Mon, 17 Jun 2013 07:00:04 GMT

Hi,

See below script it's very helpful for you

Ex:

Temp:

LOAD Concat(item,',') as ConcatItem;

LOAD * INLINE [

item

];

LET vitemString=Peek('ConcatItem',0,'Temp');

For your Script see below syntax:

Ex2:

Temp:

LOAD Concat(item,',') as item;

SQL SELECT DISTINCT item FROM table...;

LET itemString = Peek('item',0,'Temp');

Re: Concat() not working in the script

Mon, 17 Jun 2013 07:06:39 GMT

TEMP:

LOAD

ITEM

FROM TABLE;

LOAD

Concat(ITEM,',') as CONCAT;

RESIDENT TEMP;

Re: Concat() not working in the script

Mon, 17 Jun 2013 07:15:42 GMT

Hi,

Thanks, I found a similar solution in the mean time:

LOAD Concat(item, ',') AS ItemConcat;

SQL SELECT item from table...;

LET itemString = peek('ItemConcat');

Regards,

Robert