Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
maternmi
Contributor II

I have to create a new field without creating a synthetic key


Hello,

in our company we have  a data modell. For my application I've created three new tables. In each table are fields which I need to create a new field calling "Pickup_Reliability_Type". I tried to join them but the consequence is a synthatic key.

What can I do to avoid this problem? Maybe there is a simple way.

I attached a word file with the used syntax for the three tables and for the new field.

Thanks for your help!

Best regards,

Michael

1 Solution

Accepted Solutions
Not applicable

Re: I have to create a new field without creating a synthetic key

Synthetic keys are usually caused due to more than 1 similar field names in joining tables.  In that case you can try renaming the fields on which you don't the join to happen.

May be you can share a sample app for more clarity.

1 Reply
Not applicable

Re: I have to create a new field without creating a synthetic key

Synthetic keys are usually caused due to more than 1 similar field names in joining tables.  In that case you can try renaming the fields on which you don't the join to happen.

May be you can share a sample app for more clarity.

Community Browser