sort records and put Null if there are more matches on key
Moderators: chulett, rschirm, roy
sort records and put Null if there are more matches on key
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
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
I cannot understand your rules for getting from your input to your output. Could you perhaps explain what your are trying to achieve?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
Re: sort records and put Null if there are more matches on k
vsi wrote: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
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
Re: sort records and put Null if there are more matches on k
what if
Location Timezone
1000 CST
1000 PST
1000 NULL
this kind of data occurs???
Location Timezone
1000 CST
1000 PST
1000 NULL
this kind of data occurs???
RohitN
Re: sort records and put Null if there are more matches on k
what if
Location Timezone
1000 CST
1000 PST
1000 NULL
this kind of data occurs???
Location Timezone
1000 CST
1000 PST
1000 NULL
this kind of data occurs???
RohitN
-
- Premium Member
- Posts: 892
- Joined: Thu Oct 16, 2003 5:18 am