Country Wise sales thru Previous()

[Anonymous]

Hi,

I tried  for country wise sales , if two rows have similar country's data ;

But I am not sure why it is not working  'USA'  ? in 'TABLE BOX'

TEMP1:

LOAD * INLINE

[

COUNTRY, PRODUCT, SALES

MEXICO, A, 10000

ENGLAND, B, 100

USA, C, 4545

FRANCE, A, 7778

FRANCE,A, 8000

USA, B, 99999

INDIA, C, 12120

]

;

NoConcatenate

TEMP2:

LOAD COUNTRY, PRODUCT, SALES ,

if(COUNTRY=PREVIOUS(COUNTRY),PREVIOUS(SALES)+SALES, NULL()) AS COUNTRYWISESALES

Resident TEMP1;

DROP TABLE TEMP1;

TABLE BOX :

[sunny_talwar · Accepted solution]

Did you forget to may be add Order By Statement here?

TEMP1:

LOAD * INLINE

[

COUNTRY, PRODUCT, SALES

MEXICO, A, 10000

ENGLAND, B, 100

USA, C, 4545

FRANCE, A, 7778

FRANCE,A, 8000

USA, B, 99999

INDIA, C, 12120

]

;

NoConcatenate

TEMP2:

LOAD COUNTRY, PRODUCT, SALES ,

  if(COUNTRY=PREVIOUS(COUNTRY),PREVIOUS(SALES)+SALES, NULL()) AS COUNTRYWISESALES

Resident TEMP1

Order By COUNTRY; //or Order By COUNTRY, PRODUCT asc/desc;

DROP TABLE TEMP1;

[alexpanjhc]

previous() will need to be used in a sorted file.

try this

TEMP1:

LOAD * INLINE

[

COUNTRY, PRODUCT, SALES

MEXICO, A, 10000

ENGLAND, B, 100

USA, C, 4545

FRANCE, A, 7778

FRANCE,A, 8000

USA, B, 99999

INDIA, C, 12120

]

;

NoConcatenate

TEMP2:

LOAD *

Resident TEMP1

order by COUNTRY, PRODUCT;

DROP TABLE TEMP1;

NoConcatenate

TEMP3:

LOAD COUNTRY, PRODUCT, SALES ,

if(COUNTRY=PREVIOUS(COUNTRY),PREVIOUS(SALES)+SALES, NULL()) AS COUNTRYWISESALES

Resident TEMP2;

DROP TABLE TEMP2;

[Anonymous]

thanks ....a lot