Data Modeling Struggles - Synthetic Keys/Table

[win_anthony]

I have 2 tables which have a number of similar field names. I am aware that renaming/removing the similar field names can remove synthetic keys but the expected output requires that I keep the fields. I have been toying around with QUALIFY but there are just so many similar fields that I am not sure if my intuition to rename all of the fields are correct. My hope is that there is another option that I have overlooked for the data modeling that can help remove the synthetic keys/table. 

How would you approach this? Below is an example of the data that I am working with. 

Table 1
Company	First Name	Last Name	EmployeeStatus	Pay	City	State	Country
McDonalds	Joe	Smith	Permanent	Hourly	New York	NY	USA
Burger King	Amy	Doe	Permanent	Hourly	Chicago	IL	USA
In & Out	Tim	Moe	Permanent	Salary	Las Vegas	NV	USA
Shake Shack	Nancy	Drew	Permanent	Salary	Miami	FL	USA

Table 2
Company	First Name	Last Name	EmployeeStatus	City	State	Country
Chick-Fil-A	Steve	Doll	Temp	Dallas	TX	USA
Popeyes	Mary	Stevens	Temp	Seattle	WA	USA
Pizza Hut	Mickey	Mouse	Temp	San Diego	CA	USA

Expected Output
Company	First Name	Last Name	EmployeeStatus	Pay	City	State	Country
McDonalds	Joe	Smith	Permanent	Hourly	New York	NY	USA
Burger King	Amy	Doe	Permanent	Hourly	Chicago	IL	USA
In & Out	Tim	Moe	Permanent	Salary	Las Vegas	NV	USA
Shake Shack	Nancy	Drew	Permanent	Salary	Miami	FL	USA
Chick-Fil-A	Steve	Doll	Temp		Dallas	TX	USA
Popeyes	Mary	Stevens	Temp		Seattle	WA	USA
Pizza Hut	Mickey	Mouse	Temp		San Diego	CA	USA

[anushree1 · Accepted solution]

how about using concatenate

[win_anthony]

It took a little while to figure out how to structure CONCATENATE but that was exactly what I needed. 

Thanks!

[Brett_Bleess]

The following Help link may be of use to others that come to this post as well:

https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/LoadData/best-p...

Regards,
Brett