Group By Field Value?

[#1]

Hello,

I have the following Problem.

I created a table that looks now like this:

But i want that there isnt a seperat row for each value. It schould looklike this:

KT00012 35000 12500

The script looks like this:

Table:

LOAD

"Profil.Contact No_"

AS "Nr",

if

("Profil.Profile Questionnaire Code" = '1_ALLG' AND Test.Profilzeilen.%LineNo >='15000'AND Test.Profilzeilen.%LineNo <='65000',Test.Profilzeilen.%LineNo) AS "Employee",

if

("Profil.Profile Questionnaire Code" = '1_ALLG' AND Test.Profilzeilen.%LineNo >='85000'AND Test.Profilzeilen.%LineNo <='155000',Test.Profilzeilen.%LineNo) AS "Amount"

RESIDENT

Profil;

I tried to use "GROUP BY" but it doesn´t work.

Hope you can help me!

Thanks a lot!

[llauses243]

Hi,

This is my offer (see Ta ble2)

Good luck, Luis.