Split Groupwise data in Pivot or Straight table

Nagaraju_KCS — Wed, 25 Nov 2020 16:16:04 GMT

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.

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....

Re: Split Groupwise data in Pivot or Straight table

sunny_talwar — Tue, 24 May 2016 02:54:15 GMT

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;