matching values through unique ID

[#1]

Hi all,

I have the following table coming in;

ID	Join_ID	Value
1	111	X
2	111
7	222	12442
4	222
224	333	TEST
6	333

If two (or more) IDs have the same Join_ID, I need their Values to be the same.

How can I do this in QV code?

Thanks!

[Clever_Anjos]

LOAD

Join_ID,

concat(Value)

resident your_table

group by Join_ID

[#3]

hi,

thanks for the help.

question: is it possible to have the final solution in the same format as my initial table using your code above? I need to keep all the fields.

thanks

[#4]

hi,

thanks for the help.

question: is it possible to have the final solution in the same format as my initial table using your code above? I need to keep all the fields.

thanks