Greetings to all! I need to see a ligth to resolve an issue in Qlik Sense. I've created one composite key with the intention of relate tables with the same columns, but the problem is that Qlik Sense throws synth keys at the end of the load.
Example of the script:
AutoNumber(C_Company_Id &'-'&C_Branch_ID) as RelCompBranch;
AutoNumber(E_Company_Id &'-'&E_Branch_ID) as RelCompBranch;
AutoNumber(I_Company_Id &'-'&I_Branch_ID) as RelCompBranch;
I've supposed that the problem was the name of the relationship (RelCompBranch) but when I changed the name the results of data were not consistent to the expected... I need to resolve this issue... Thanks in advance!