LOGIC

[#1]

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..

[#2]

Please find attachement

hope this helps

[jagan]

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.

[aveeeeeee7en]

Hi Rahul

With Reference of Jagan Mohan Code i have worked on the Solution.

See the Attached Files.

Regards

Aviral