New value in a field representing all values

[sujayrpatil]

Hi,

I have data set similar to the below table. I am plotting a bar chart to Customers vs City.

City	count of Customers
A	20
B	30
C	40
D	50

The requirement is to get one more value in City column  something like 'ALL' which will be combining all cities and will show total customers. I need this addition of new value to happen in Load script as I have other transformations to run after this change.

Expected Result:

City	count of Customers
A	20
B	30
C	40
D	50
All	140

Thanks In advance for  your replies.

Regards,

Sujay.

[avinashelite · Accepted solution]

If you have limited values try like this 

LOAD * Inline

[

City,City_Updated

A,ALL

B,ALL

C,ALL

D,ALL

A,A

B,B

C,C

D,D

];

and use the City_updates column in the front end