topic Re: More value in one field in QlikView

More value in one field

marcobombo — Thu, 11 Jul 2013 08:48:23 GMT

Hi everybody,

I have a problem with a new definition of table.

I have this table

 Tmp:
LOAD * INLINE [
    Key, Value
    A, 10
    A, 11
    B, 10
    B, 11
    B, 12
];

and I want to obtain this risult:

Key Value

A 10,11

B 10,11,12

Can anyone help me?

Thanks

kaushiknsolanki — Thu, 11 Jul 2013 08:55:06 GMT

Hi,

Try this.

Load Key,Concate(Value,',') as New_Value

Resident Tmp Group by Key;

Regards,

Kaushik Solanki

Thu, 11 Jul 2013 08:59:40 GMT

try this

Tmp:

LOAD * INLINE [

Key, Value

A, 10

A, 11

B, 10

B, 11

B, 12

];

LOAD Key, concat(Value,',') as value_new Resident Tmp group by Key;

output like this

see attachement

nizamsha — Thu, 11 Jul 2013 09:01:01 GMT

then u have to concat the value

load

key,value

concat(distinct value.'') as value1,

concat(distinct key .'') as key1

resident table;

marcobombo — Thu, 11 Jul 2013 09:11:15 GMT

Excactly.

Thanks