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