topic Re: Reg-grouping in QlikView

Reg-grouping

Mon, 13 Jul 2015 05:04:17 GMT

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 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 3MG 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 3MG TAB 30'S (S)

AMARYL 2MG TAB 30'S (S)

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

Re: Reg-grouping

settu_periasamy — Mon, 13 Jul 2015 06:38:45 GMT

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;

Re: Reg-grouping

Mon, 13 Jul 2015 06:59:22 GMT

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 .

Re: Reg-grouping

settu_periasamy — Mon, 13 Jul 2015 07:16:07 GMT

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.