Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear All,
I hav a code column and i want to create a group of AA,BA,CA where the logic is that first we have to make a goup of OOO,XXX,BBB and in that group the like
| ABBBB01 |
| ABBBB05 |
| AABBB08 |
| BBOOO02 |
| BAOOO03 |
| BCOOO04 |
| CAXXX01 |
| CBXXX02 |
| CCXXX03 |
| CDXXX04 |
and then we have to sort the first two alphabet of each group and take the top alphabet AA , BA, CA in a group..
plz reply soon..
Please find attachement
hope this helps
Hi Rahul,
Try like this
Code:
LOAD Code,
Mid(Code, 3, 3) AS Group_code,
Left( Code,2) AS SubGroup_code
FROM DataSource;
Regards,
Jagan.
Hi Rahul
With Reference of Jagan Mohan Code i have worked on the Solution.
See the Attached Files.
Regards
Aviral