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