Hi
I've table data in the below format.
Lkey DefectName LensResult A B X Y
101 EdgeChip Fail 4 8 1 2
101 EdgeChip Fail 2 5 3 6
101 EdgeTear Fail 3 1 5 7
Now i need to show the result as below
Lkey MInA MaxA MinB MaxB
101 2 4 1 8
One way:
To achive this i have take straight table and dimension as Lkey and expression as Min(A),Max(A),Min(B),Max(B). Now the result is as i want i can see. But the problem is when i add X, Y in dimension it shows different data. I want to know is this is the way to summarize the data. I want to summarize all the fileds except what the fields which we are using for Min,Max calculation.
SecondWay:
Load Lkey,
DefectName,
LensResult,
Min(A),
Max(A),
Min(B),
Max(B)
from table1.qvd
Group By
Load Lkey,
DefectName,
LensResult ;
- But it is consuming lot of time to load above table in my application b'coz i've more than 100 fields with large amount of data to summarize. Just i've shown u with few fileds only.
Which is the best way to achive the summarize data or is there any way to achive this.
Can anyone please help me on this.
For your reference i'm attaching my file
