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

[arulsettu]

try this

KeepChar(Product_name ,'0123456789') as Product_a,

PurgeChar(Product_name ,'0123456789') as Product_b

[anbu1984 · Accepted solution]

Do you have any logic to split into ProductA and ProductB?

If it is hard-coded values, then you can create Inline table like below

Load * Inline [

Product_Name,ProductGroup

251,ProductA

252,ProductA

...

587,ProductA

588,ProductB

...

965,ProductB ];

[Anonymous]

Hi John

  I guess based on colour you may not able restrict in the script. Kindly let us know if there is any other logic or what you want to do?

-Jay

[Gysbert_Wassenaar]

LOAD * INLINE  [

Product_name, Group

251,ProductA

252,ProductA

256,ProductA

263,ProductA

355,ProductA

356,ProductA

400,ProductA

575,ProductA

576,ProductA

577,ProductA

578,ProductA

579,ProductA

580,ProductA

581,ProductA

582,ProductA

583,ProductA

584,ProductA

585,ProductA

586,ProductA

587,ProductA

588,ProductB

589,ProductB

590,ProductB

591,ProductB

592,ProductB

593,ProductB

594,ProductB

595,ProductB

596,ProductB

597,ProductB

598,ProductB

599,ProductB

AMP,ProductB

ECP,ProductB

FMT,ProductB

KAR,ProductB

LAS,ProductB

MIL,ProductB

SEA,ProductB

SIP,ProductB

SYK,ProductB

243,ProductB

244,ProductB

245,ProductB

248,ProductB

255,ProductB

265,ProductB

527,ProductB

528,ProductB

529,ProductB

530,ProductB

531,ProductB

532,ProductB

533,ProductB

534,ProductB

535,ProductB

536,ProductB

537,ProductB

538,ProductB

546,ProductB

570,ProductB

571,ProductB

572,ProductB

940,ProductB

965,ProductB

];

[#6]

HI JOHN

NOT based on colors but need to differentiate that so changed colors, but all belongs to one field Product_Name

[#7]

HI

gwassenaar

Anbu cheliyan

I am trying this way

[Anonymous]

HI John

  it will be difficult to identify if you don't have any flags/conditions. Other may give right ans

-Jay

[sunny_talwar]

Try the following script:

Temp:

LOAD * INLINE [

    Product_Name

    AMP

    TFD

    FMT

    KAR

    LAS

    MIL

    SEA

    SIP

    SYK

    527

    528

    529

    530

    531

    532

    533

    534

    535

    536

    537

    538

    546

    570

    571

    572

    573

    940

    965

    243

    244

    245

    248

    251

    252

    255

    256

    263

    265

    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

];

Table1:

LOAD Product_Name as ProductA

Resident Temp

Where IsText(Product_Name) or Match(Product_Name, 527,528,529,530,531,532,533,534,535,536,537,538,546,570,571);

Table2:

LOAD Product_Name as ProductB

Resident Temp

Where not Exists(ProductA, Product_Name);

DROP Table Temp;

HTH

Best,

Sunny

[#10]

HI All

I am Loading this Product_name From a Product Table

I am Using

     Product_Name

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');

is there any Chance I can separate here Itself