group by Field Values

[#1]

HI Experts

I have a field Product_name and the field Values are Below

I want to classify the values in to two groups, the field value in blue color into  ProductA and rest into ProductB, and I want to create a listbox with ProductA and ProductB, and if Makr selection in that listbox my app should show the changes according to it, please Help

251
252
256
263
355
356
400
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
AMP
ECP
FMT
KAR
LAS
MIL
SEA
SIP
SYK
243
244
245
248
255
265
527
528
529
530
531
532
533
534
535
536
537
538
546
570
571
572
940
965

[sunny_talwar]

May be this way:

If(Match(Product_Name, 'AMP','ECP','FMT','KAR','LAS','MIL','SEA','SIP','SYK', ....) as ProductA,

If(Match(Product_Name, .....) as ProductB

FROM

[\\TVHC2-QVP01\Data\QVDs\DIMENSIONAL\KPRODUCT.qvd]

(qvd)

where Mixmatch(PC, '243', '244', '245', '248', '251', '252', '255', '256','263','265','355','356','357','400','572',

'575','576','577','578','579','580','581','582','583','584','585','586','587','588','589','590','591','592','593','594',

'595','596','597','598','599','527','528','529','530','531','532','533','534','535','536','537','538','546','570','571',

'572','573','940','965','AMP','ECP','FMT','KAR','LAS','MIL','SEA','SIP','SYK');

[anbu1984]

Load

Product_Name,

If(Match(Product_Name,'251','252',....'587'),'ProductA',ProductB') As ProdGroup //Mention all the Product names belong to ProductA in this Match()

FROM

[\\TVHC2-QVP01\Data\QVDs\DIMENSIONAL\KPRODUCT.qvd]

(qvd)

where Mixmatch(PC, '243', '244', '245', '248', '251', '252', '255', '256','263','265','355','356','357','400','572',

'575','576','577','578','579','580','581','582','583','584','585','586','587','588','589','590','591','592','593','594',

'595','596','597','598','599','527','528','529','530','531','532','533','534','535','536','537','538','546','570','571',

'572','573','940','965','AMP','ECP','FMT','KAR','LAS','MIL','SEA','SIP','SYK');

[#4]

HI Sunny

i tried your way

it says expression error

Error in Expression:if takes 2-3 parametres

[sunny_talwar]

Sorry forgot to close the if statement:

If(Match(Product_Name, 'AMP','ECP','FMT','KAR','LAS','MIL','SEA','SIP','SYK', ....), Product_Name) as ProductA,

If(Match(Product_Name, .....), Product_Name) as ProductB

FROM

[\\TVHC2-QVP01\Data\QVDs\DIMENSIONAL\KPRODUCT.qvd]

(qvd)

where Mixmatch(PC, '243', '244', '245', '248', '251', '252', '255', '256','263','265','355','356','357','400','572',

'575','576','577','578','579','580','581','582','583','584','585','586','587','588','589','590','591','592','593','594',

'595','596','597','598','599','527','528','529','530','531','532','533','534','535','536','537','538','546','570','571',

'572','573','940','965','AMP','ECP','FMT','KAR','LAS','MIL','SEA','SIP','SYK');

[#6]

HI Sunny

This is Loading all the Product_name some 800,560 not the particular ones

[#7]

HI

Anbu Cheliyan

This  Loading the entire Product table but not the expected ones

[#8]

HI

I Tried the Way Mentioned By Abucheliyan & Gysbert

It Worked

HI All

Thanks for your Help