sort records and put Null if there are more matches on key

[vsi]

I have data like this

Location Timezone
1000 CST
1000 PST
1000 EST
1000
1100 IST
1100
1200
1300 GMT
1300 CST

My Output should look like

Location Timezone
1000
1100 IST
1200
1300

How Can I get this .....sort keychange is not helping

i.e if there are multiple timezones i need to keep null
else data

[ArndW]

I cannot understand your rules for getting from your input to your output. Could you perhaps explain what your are trying to achieve?

[ArndW]

I have data like this

Location Timezone
1000 CST
1000 PST
1000 EST
1000
1100 IST
1100
1200
1300 GMT
1300 CST

My Output should look like

Location Timezone
1000
1100 IST
1200
1300

How Can I get this .....sort keychange is not helping

i.e if there are multiple timezones i need to keep null
else data

[chulett]

Your example doesn't match your "i.e." written description.

[vsi]

iF THERE ARE multiple timezones on location
timezone should be null
if there is only one timezone ..Then I have to take the timezone as it is

if the location has a null timezone and a timezone . I have to take timezone

[Sainath.Srinivasan]

Use an aggregator to get the distinct timeZone count and set those with > 1 as NULL.

[RohitNara]

what if
Location Timezone
1000 CST
1000 PST
1000 NULL
this kind of data occurs???

[RohitNara]

what if
Location Timezone
1000 CST
1000 PST
1000 NULL
this kind of data occurs???

[Sreenivasulu]

'Null' is empty ie like a blackhole. You have mentioned 'null' as a word then you need to handle this record before this stage

Regards
Sreeni