Reg-grouping

[#1]

Hi TEAM

I have filed like the below and i have grouop them.I i want to get the fields of AMARYL  2MG TAB 30'S UNDER ONE AND AMARYL  3MG TAB 30'S UNDER ONE ,Like this i have field  AMARYL  300 MG UNDER ONE .CAN ANY ONE HELP ME OUT FROM THIS.

AMARYL TAB 3MG 2 X 15'S

AMARYL  2MG TAB 30'S

AMARYL  2MG TAB 30'S

AMARYL  2MG TAB 30'S

AMARYL  2MG TAB 30'S

AMARYL M SR F/C TAB 2/500MG 30S

AMARYL  2MG TAB 30'S

AMARYL  3MG TAB 30'S

AMARYL  2MG TAB 30'S

AMARYL  3MG TAB 30'S

AMARYL  2MG TAB 30'S

AMARYL  2MG TAB 30'S

AMARYL  2MG TAB 30'S

AMARYL  2MG TAB 30'S

AMARYL  3MG TAB 30'S

AMARYL  2MG TAB 30'S

AMARYL  2MG TAB 30'S

AMARYL  2MG TAB 30'S

AMARYL  2MG TAB 30'S

AMARYL  2MG TAB 30'S

AMARYL  2MG TAB 30'S (S)

AMARYL  3MG TAB 30'S (S)

AMARYL M SR F/C TAB 2/500MG 30S (S)

AMARYL  2MG TAB 30'S (S)

AMARYL  2MG TAB 30'S (S)

AMARYL  3MG TAB 30'S (S)

AMARYL  2MG TAB 30'S (S)

AMARYL  2MG TAB 30'S (S)

AMARYL M SR F/C TAB 2/500MG 30S (S)

i

[settu_periasamy]

Hi,

Not clearly understood. But may be like this

A:
LOAD * INLINE [
  Check
    "AMARYL TAB 3MG 2 X 15'S"
    "AMARYL  2MG TAB 30'S"
    "AMARYL  2MG TAB 30'S"
    "AMARYL  2MG TAB 30'S"
    "AMARYL  2MG TAB 30'S"
    AMARYL M SR F/C TAB 2/500MG 30S
    "AMARYL  2MG TAB 30'S"
    "AMARYL  3MG TAB 30'S"
    "AMARYL  2MG TAB 30'S"
    "AMARYL  3MG TAB 30'S"
    "AMARYL  2MG TAB 30'S"
    "AMARYL  2MG TAB 30'S"
    "AMARYL  2MG TAB 30'S"
    "AMARYL  2MG TAB 30'S"
    "AMARYL  3MG TAB 30'S"
    "AMARYL  2MG TAB 30'S"
    "AMARYL  2MG TAB 30'S"
    "AMARYL  2MG TAB 30'S"
    "AMARYL  2MG TAB 30'S"
    "AMARYL  2MG TAB 30'S"
    "AMARYL  2MG TAB 30'S (S)"
    "AMARYL  3MG TAB 30'S (S)"
    AMARYL M SR F/C TAB 2/500MG 30S (S)
    "AMARYL  2MG TAB 30'S (S)"
    "AMARYL  2MG TAB 30'S (S)"
    "AMARYL  3MG TAB 30'S (S)"
    "AMARYL  2MG TAB 30'S (S)"
    "AMARYL  2MG TAB 30'S (S)"
    AMARYL M SR F/C TAB 2/500MG 30S (S)
];




Load Distinct Check,Trim(Replace(Check,'(S)','')) as check1
Resident A;


DROP Table A;

[#3]

Hi

Thanks for the reply ,yes i want like this iam writing  script here

#CNTRY_ITMCODE	As	#CNTRY_ITMCODE_S,
#CNTRY_PRODID	As	#CNTRY_PRODID_S,
#CNTRY_PRODID1	As	#CNTRY_PRODID1_S,
#ITEMCODE	As	#ITEMCODE_S,
Brand	As	Brand_S,
BU	As	BU_S,
BU_New	As	BU_New_S,
BU_Old	As	BU_Old_S,
DSR_Brand	As	DSR_Brand_S,
Franchise	As	Franchise_S,
Group3	As	Group3_S,
Group3PlusDS_temp	As	Group3PlusDS_temp_S,
IT_PRODID	As	IT_PRODID_S,
Itemname	As	Itemname_S,
ITP_COUNTRY	As	ITP_COUNTRY_S,

here  this is script and we are getting fields in the Itemname_s filed.Could you please let me know where can i write here .

[settu_periasamy]

Instead of Itemname,

you can try like this

Trim(Replace(Itemname,'(S)','')) as Itemname_S

This is kind of hard coding. if you want to do the different replace value this wont work.