How merge rows in logic table?

[#1]

Hi All.

In single logic table I have this data:

Name	Parameter 1	Parameter 2	Parameter 3
Name 1	10	-	-
Name 1	-	20	-
Name 1	-	-	30
Name 2	40	-	-
Name 2	-	50	-
Name 2	-	-	60

How merge this data to single row?

Name	Parameter 1	Parameter 2	Parameter 3
Name 1	10	20	30
Name 2	40	50	60

Thank you.

[tresesco]

Front end solution:

Straight table:

Dim: Name

1st  Exp: Sum(Parameter1)

2nd  Exp: Sum(Parameter2)

3rd  Exp: Sum(Parameter3)

[ashfaq_haseeb]

Hi,

may be like this.

Regards

ASHFAQ

[#4]

It's great, but I need merged rows in script, not in table (diagram).

[nagaiank]

If you want to merge the rows in script, you may try

MergedTable:

NoConcatenate
LOAD Name, Sum([Parameter 1]) as [Parameter 1], Sum([Parameter 2]) as [Parameter 2], Sum([Parameter 3]) as [Parameter 3]
Resident OriginalTable Group By Name;

Drop Table OriginalTable;

[tresesco]

In that case, you might try generic load , see : Here for details.

Note: The code given by Rob Wunderlich at the comment-reply section is also impotant I felt.