topic Re: Generic Keys in QlikView

Generic Keys

Tue, 23 Dec 2014 14:38:30 GMT

Hi Guys,

I have the following problem:

I have one table 'Sales' with a key field SalesId and a nother table left joining Sales called SalesResult with a field SalesResultId. However I would like to create an generic key out of SalesId&'|'&SalesResultId to create an unique identifier for all Sales.

Can someone give me an easy example how to do this?

Best

Harry

Re: Generic Keys

saumyashah90 — Tue, 23 Dec 2014 14:43:24 GMT

Just make a composite key

Load

SalesId&'|'&SalesResultId as Comp_Key,

Xyz,

from abc;

Re: Generic Keys

Tue, 23 Dec 2014 14:47:32 GMT

Thanks, Saumya! But this is not working for me because you have table SalesResult is joining table Sales. Therefore SalesResultId is unknown in Sales. I tried the following but got a synthetic key:

LEFT JOIN (Sales)

LOAD

SalesId&'|'&SalesResultId as Comp_Key

RESIDENT Sales;

Re: Generic Keys

saumyashah90 — Tue, 23 Dec 2014 14:52:41 GMT

Can you please send me your script.

I will edit and let you know the correct path.

Re: Generic Keys

its_anandrjs — Tue, 23 Dec 2014 14:55:25 GMT

Hi,

Please provide sample file this will more easy.

Ex:- For composite keys try this ways and let me know.

tmpTable:

Load

SalesId

From Sales;

Left Join(tmpTable)

Load

SalesResultId

From SalesResult;

Load

SalesId,

SalesResultId,

SalesId&'|'&SalesResultId as %Key

Resident tmpTable;

Drop Table tmpTable;

Regards

Anand

Re: Generic Keys

Tue, 23 Dec 2014 18:42:04 GMT

Hi Harry,

I hope two columns SalesId,SalesResultId available in two tables. so at this point synthetic keys will generate.

If you are trying to avoid synthetic key, Please follow this

Sales -- keep it in two fields and generate a new column with concatenate

SalesResult -- common two fileds are commented and generate a new column with concatenate, its associated with previous one.

But two column names are same. then only associated.

Regards,

Sub2u.