Split Groupwise data in Pivot or Straight table

[qv_testing]

HI Community,

I have Straight table, Here i have ProductName, in ProductName i have many attributes.

My requirement i have to split product Group wise data..

Sample Example:    These 4 product names one group and remaining are another group.

Product	Category	Amount
AAA Running Shoe	Baby Clothes	100
Aino Shoes	Children's Clothes	200
Atles Lussekofta	Men's Clothes	300
Baby Dark Lounge Suit	Men's Footwear	400

Client wants only these names only,

I have taken one inline table..

Like:

Load * Inline [ 

MappField

AAA Running Shoe

Aino Shoes

Atles Lussekofta

Baby Dark Lounge Suit

];

But this is not associating to ProductName..

Any better Approach..??

Thanks in Advance....

[sunny_talwar]

May be you want something like this:

LOAD Product

          Category,

          Amount,

          If(Match(Product, 'AAA Running Shoe', 'Aino Shoes', 'Atles Lussekofta', 'Baby Dark Lounge Suit'), 'Group1', 'Group2') as Group

FROM Source;