Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
maternmi
Creator II
Creator 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

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.

View solution in original post

1 Reply
Not applicable

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.

View solution in original post