Sub Count in a field

[Kohli]

I have filed like

City

Bangalore

Hyderabad

chennai

chennai

chennai

Bangalore

Hyderabad

chennai

I want ouput

Bannglore- 2

Chennai- 4

hyderabad-2

[Anil_Babu_Samineni]

Are you want this in script / UI ??

[Kohli]

In UI

[giovanneb]

Hi, Follow

tmpCity:

LOAD * Inline [

City

Bangalore

Hyderabad

chennai

chennai

chennai

Bangalore

Hyderabad

chennai];

City:

LOAD

City,

count(City) as Count

Resident tmpCity

Group by City;

DROP Table tmpCity;

[giovanneb]

!

[vamsee]

Script:

LOAD

City,

City &'-'& Count(City) as New_Column

Group By City;

[Anil_Babu_Samineni]

Check giovanneb reply, If that helps? But, The way your question is different. If it not suits, Can i take little more explanation from you?