As you said you have several columns with the same name, you probably are dealing with similar information. So, you can concatenate the several tables and, you can create an extra field that can identify the source or kind of information. All columns will then be stored in one single table in qlik sense. Those columns that are not present in certain source table wil receive a null.
Hope this helped you
The only solution you could impose is to remove the columns/fields exist in the other table. But prior removing them, make sure they were not necessary already, since they already existed in the other table.. and yet we are talking same data.
In any case that the same columns/fields were not related, then this is the time that you should utilize alias or 'AS' in renaming the fields.
Hope it helps!
Ways to get rid of Synthetic Keys:
1. Using QUALIFY
This enforces QlikView to qualify all/selected fields.
If you alias the conflicting fields.
3. Remove unnecessary Fields.
4. Auto number
If you need to concat the Syn Key candidate fields and create your own key,
you can use Auto-number/Autonumberhash128/Autonumberhash256 function.
This will create a unique integer value for each distinct combination of the concatenated columns.