Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
surajap123
Creator II
Creator II

linking field via key

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)

Capture.JPG

Please help!

1 Reply
shiveshsingh
Master
Master

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$);