Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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