linking field via key

[surajap123]

Hi All,

I want to link my derived field 'Sector', directly to the 'Product' field via a key field. So Sector field should be in a separate table.

My Requirement is, once the sector is created based on Category field, I want the Sector field to be linked DIRECLY to the correct Product values through a key field(and not via Category field)

Please help!

[shiveshsingh]

Like this?

Sector:

LOAD if(WildMatch(Category,'B*'),'A1',

if(WildMatch(Category,'P*'),'A2')) as Sector

FROM

[.\many to manyData.xls]

(biff, embedded labels, table is Sheet1$);

Category_Temp:

load Category, Product, if(WildMatch(Category,'B*'),'A1',

if(WildMatch(Category,'P*'),'A2')) as Sector

FROM

[.\many to manyData.xls]

(biff, embedded labels, table is Sheet1$);