topic Synthetic keys forming- please help in QlikView

Synthetic keys forming- please help

qvqfqlik — Mon, 27 Jun 2016 17:52:47 GMT

synthetic keys getting created.

however, the script ran fine.

Please help.

Re: Synthetic keys forming- please help

mgranillo — Mon, 27 Jun 2016 18:49:21 GMT

A synthetic key is okay depending on your use case. If you want to remove it, concatenate the fields in your synthetic key and remove or rename the fields.

Re: Synthetic keys forming- please help

qvqfqlik — Mon, 27 Jun 2016 19:01:04 GMT

In the file i sent and from the synthetic key key message, how do i concatenate?

Re: Synthetic keys forming- please help

karthikoffi27se — Mon, 27 Jun 2016 19:27:04 GMT

Hi Prithvi

The best solution to overcome synthetic key is follow any one of these steps based on your requirement.

$SYNTHETIC KEY

PRODUCT_KEY+FIXED_COST+VARIABLE_COST+TOTAL_COST  

1. You can rename the field names

SalesTable:

Load

PRODUCT_KEY,

FIXED_COST as SALES_FIXED_COST,

VARIABLE_COST as SALES_VARIABLE_COST,

TOTAL_COST AS SALES_TOTAL_COST

From Sales.qvd

;

CostTable:

Load

PRODUCT_KEY,

FIXED_COST as COST_FIXED_COST,

VARIABLE_COST as

COST_VARIABLE_COST,

TOTAL_COST AS COST_TOTAL_COST

From Cost.qvd

;

2. You can remove or comment the common field names apart from primary key.

SalesTable:

Load

PRODUCT_KEY,

FIXED_COST,

VARIABLE_COST,

TOTAL_COST

From Sales.qvd

;

CostTable:

Load

PRODUCT_KEY,

//FIXED_COST

//VARIABLE_COST

//TOTAL_COST

From Cost.qvd

;

3. The final option is to use the Qlik function qualify and unqualify

Qualify function will add the table name in front of your field names

Qualify *;

Unqualify PRODUCT_KEY;

SalesTable:

Load

PRODUCT_KEY,

FIXED_COST,

VARIABLE_COST,

TOTAL_COST

From Sales.qvd

;

CostTable:

Load

PRODUCT_KEY,

FIXED_COST,

VARIABLE_COST,

TOTAL_COST

From Cost.qvd

;

Unqualify *;

Hope this should resolve your problem.

Many Thanks

Karthik

Re: Synthetic keys forming- please help

Clever_Anjos — Mon, 27 Jun 2016 19:46:49 GMT

Your file came empty

Re: Synthetic keys forming- please help

qvqfqlik — Mon, 27 Jun 2016 20:00:35 GMT

Synthetic key here is not due to this piece of code... I fixed it... Thanks for looking into.