[SOLVED] How to culculate the rank value in DataMicgrator?
I want transform the data to target table, and add a culculate column, the column value is the rank depent other 2 column.For example: Source data: US Product1 100 US Product2 200 UK Product1 300 UK Product2 400
The result data:
US Product1 100 1 US Product2 200 2 UK Product1 300 1 UK Product2 400 2This message has been edited. Last edited by: <Kathryn Henning>,
WebFOCUS 8001 Windows7 Output: PDF, Excel, COMT
March 19, 2013, 07:23 AM
Alex
Sort by country/bt product by value and create a Counter with a COMPUTE using "LAST" to reset the counter.
TABLE FILE CAR
SUM
SALES
COMPUTE COUNTER/I1 = IF COUNTRY EQ LAST COUNTRY THEN COUNTER +1 ELSE 1;
BY COUNTRY
BY CAR
END
This message has been edited. Last edited by: Alex,
WF 7.7.04, WF 8.0.7, Win7, Win8, Linux, UNIX, Excel, PDF
March 26, 2013, 05:11 AM
jay sun
Thanks, Alex Can I get more meaningful result about the "RANK":