adding fields

[#1]

Guys i have the following case (see attached the 2 excel files). I want to find a way to add up the fields having the same case id

[Gysbert_Wassenaar · Accepted solution]

What do you mean 'add up'. Strings don't add up very well. Numbers work a lot better. If you want to concatenate the string values you can use the concat function:

LOAD case, concat(description, '\') as description_list

FROM ...

GROUP BY case;

[#3]

Thanks for your support