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