topic Re: How merge rows in logic table? in QlikView

How merge rows in logic table?

Wed, 20 Aug 2014 13:11:35 GMT

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.

Re: How merge rows in logic table?

tresB — Wed, 20 Aug 2014 13:18:55 GMT

Front end solution:

Straight table:

Dim: Name

1st Exp: Sum(Parameter1)

2nd Exp: Sum(Parameter2)

3rd Exp: Sum(Parameter3)

Re: How merge rows in logic table?

ashfaq_haseeb — Wed, 20 Aug 2014 13:19:26 GMT

Hi,

may be like this.

Regards

ASHFAQ

Re: How merge rows in logic table?

Wed, 20 Aug 2014 13:22:09 GMT

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

Re: How merge rows in logic table?

nagaiank — Wed, 20 Aug 2014 13:27:00 GMT

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;

Re: How merge rows in logic table?

tresB — Wed, 20 Aug 2014 13:28:23 GMT

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.