topic Build master key in QlikView

Build master key

martynlloyd — Thu, 05 May 2016 15:38:37 GMT

Hi,

I have two tables:

PRODUCT

100

200

300

OPTIONS

I need to build a key to identify unique configurations - e.g

100_ADEF

100_BCDEF

200_DEF

200_BDEF

I have a few thousand products, and each one has between 100 and 200 options.

What would be a good way to do this?

Regards,

Marty.

Re: Build master key

swuehl — Thu, 05 May 2016 17:43:19 GMT

How are the OPTIONS linked to your PRODUCT?

Or, asking in other words, how do you derive your unique configurations from the two tables?

I am absolutely unsure what you are trying to achieve. Have you considered using a link table between PRODUCT and OPTIONS table, i.e for a configuration like 100_ADEF, you would built a link table like

LOAD CONFIG,
  PRODUCT,
  Mid(CONFIG, LEN1+iterno(),1) as OPTION
WHILE iterno()<= LEN2;
LOAD *, Subfield(CONFIG,'_',1) as PRODUCT, Len(Subfield(CONFIG,'_',1))+1 as LEN1, Len(Subfield(CONFIG,'_',2)) as LEN2 INLINE [
CONFIG
100_ADEF
100_BCDEF
200_DEF
200_BDEF
];