When the synthetic keys are avoided using AS key, resuts produced seem in correct

[nevilledhamsiri]

Dear All,

I have linked two tables to produce results as I wanted. In the process, I am getting synthetic keys. (Branch_code & ME_CODE). But with synthetic keys, the results produced are ok. But I prefer expected results without  the synthetic keys. I did a left join too hoping to avoid synthetic keys but nothing happened. Will some one see where I have gone wrong & please correct me to get the expected results!

Thanks

Neville

[stabben23]

Maybe you should create a composite key With the two Fields, Field1 &'-'& Field2 as Key.  Left Join is not the best way to reduce synthetic keys, it better to rename the Fields. And sometimes Synthetic key is not as bad as the rumor.

[karthikoffi27se]

Hi Neville,

You can rename the branch code to 'BRANCH CODE1" in any one of the table which will remove your synthetic table

Many Thanks

Karthik

[nevilledhamsiri]

Hi, Johansson, Selvaraj,

Thanks for your reply. Dear I renamed one of the field which helped me to avoid the composite keys but results produced are in correct. But when it is as it is with synthetic keys result are good. Why is that?. You could see that if I rename the Branch code, Refund value shows abnormally high which is not the actual case.

Thanks

Neville

[vamsee]

Hi Neville,

I don't understand why you are trying to avoid the composite key.

Anyway, please see the attached and see if it works.

Thanks

Vamsee

[nevilledhamsiri]

Dear Vamsee

Can you please send me the working! I am on  a personnel edition as well

Thanks

Neville

[vamsee]

Hi Neville,

Apologies for the delayed response.

PFA

Thanks

Vamsee

[vamsee]

Hello,

Reminder to please mark the correct answer or helpful.

Qlik Community Tip: Marking Replies as Correct or Helpful

Thanks.