how to exclude several items from one group?

[#1]

Hi,

I have a product group ('Group A') that consists of 100 products. I want to exclude 5 products out of this group and create a group without those products ('Group A-').

Can anyone suggest how to create such a group at the script level?

Thanks

Thomas

[alexandros17]

LOAD

     ....

     myProduct,

     if(myProduct = 'exl1' or myProduct = 'exl2' ..... , 'E', 'I') as flag exclude

....

In this way you can use the flag to identify product you need, and

you can use the flag in all the expressions even list box

Hope it helps

[#3]

Hi

T_Map:

Mapping load

ProductId,

'A-'     as Group

resident Yourfile

WHERE ProductId in (11,22,33,44,55)   (for example)

LOAD

*,

applymap('T_Map', ProductId, '?')     as Group

From yourfile;

You can also manage a specific file or LOAD * INLINE from these products

best regards

Chris