topic Re: Creating a comma separated list in QlikView

Creating a comma separated list

Mon, 25 Sep 2017 17:41:22 GMT

Hi All,

I'm looking to perform the following task in QV:

How can i achieve this ? I imagine there is a previous command involved. Just unsure as to how to frame the logic.

All suggestions are welcome. Thanks

sunny_talwar — Mon, 25 Sep 2017 17:50:05 GMT

May be like this

LOAD Value,

Alt(Peek('New Column'), '') & ',' & Value as [New Column]

FROM ...

Frank_Hartmann — Mon, 25 Sep 2017 18:45:01 GMT

or maybe:

LOAD *,

if(Peek('New Column')<>Null(),Peek('New Column'),Null())& Value as [New Column];

LOAD * INLINE [

Value

];

sunny_talwar — Mon, 25 Sep 2017 18:55:02 GMT

My intentions were right, but I should have thought through or tested my code .

Slight improvement

Table:

LOAD *,

Peek('New Column') & Value & ',' as [New Column];

LOAD * INLINE [

Value

];

FinalTable:

NoConcatenate

LOAD Value,

Left([New Column], Len([New Column]) - 1) as [New Column]

Resident Table;

DROP Table Table;

Tue, 26 Sep 2017 17:41:30 GMT

Thanks all.