topic Re: $syn in QlikView

$syn

sagaraperera — Thu, 23 Apr 2015 06:14:34 GMT

I want to withdraw $ syn are cause it to below picture. Why are the sketch and description, claims a table number. Method to clarify concerns, and to make the table from $ syn.

sagara

Re: $syn

prma7799 — Thu, 23 Apr 2015 06:17:26 GMT

Hi,

Can you post some sample data?

Or you can you Qualify , unqualify operator to remove $syn.

Thanks

Re: $syn

PrashantSangle — Thu, 23 Apr 2015 06:26:27 GMT

Hi,

There are various solutions to avoid Synthetic Key.

Some of them are.

1)Create Link Table

2) Create Key and Rename other fields

Read article wriiten by Henric about Data Modeling gives you brief idea.

Search it, you will found so many good solutions.

Regards

Re: $syn

jagan — Thu, 23 Apr 2015 06:30:54 GMT

Hi,

You have more than one field common in P&LBudDate and P&LDATA2011-2014, that is why you are getting this Synthetic key. To overcome this you need to Concatenate both the tables like this

Data:

LOAD

'Budget' AS DataType

FROM P&LBudDate;

Concatenate(Data)

LOAD

'Actual' AS DataType

FROM P&LDATA2011-2014;

Regards,

Jagan.