Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
cancel
Showing results for 
Search instead for 
Did you mean: 
marcobombo
Contributor
Contributor

More value in one field

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

1 Solution

Accepted Solutions
Not applicable

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

Keyvalue_new
A10,11
B10,11,12

see attachement

View solution in original post

4 Replies
kaushiknsolanki

Hi,

     Try this.

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

     Resident Tmp Group by Key;

Regards,

Kaushik Solanki

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".
Not applicable

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

Keyvalue_new
A10,11
B10,11,12

see attachement

View solution in original post

nizamsha
Specialist II
Specialist II

then u have to concat the value

load

key,value

,

concat(distinct value.'') as value1,

concat(distinct key .'') as key1

resident table;

marcobombo
Contributor
Contributor
Author

Excactly.

Thanks