Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

Data Modeling Struggles - Synthetic Keys/Table

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
CompanyFirst NameLast NameEmployeeStatusPayCityStateCountry
McDonaldsJoeSmithPermanentHourlyNew YorkNYUSA
Burger KingAmyDoePermanentHourlyChicagoILUSA
In & OutTimMoePermanentSalaryLas VegasNVUSA
Shake ShackNancyDrewPermanentSalaryMiamiFLUSA

 

Table 2
CompanyFirst NameLast NameEmployeeStatusCityStateCountry
Chick-Fil-ASteveDollTempDallasTXUSA 
PopeyesMaryStevensTempSeattleWAUSA 
Pizza HutMickeyMouseTempSan DiegoCAUSA 

 

Expected Output
CompanyFirst NameLast NameEmployeeStatusPayCityStateCountry
McDonaldsJoeSmithPermanentHourlyNew YorkNYUSA
Burger KingAmyDoePermanentHourlyChicagoILUSA
In & OutTimMoePermanentSalaryLas VegasNVUSA
Shake ShackNancyDrewPermanentSalaryMiamiFLUSA
Chick-Fil-ASteveDollTemp DallasTXUSA
PopeyesMaryStevensTemp SeattleWAUSA
Pizza HutMickeyMouseTemp San DiegoCAUSA
1 Solution

Accepted Solutions
Highlighted
Specialist II
Specialist II

how about using concatenate

View solution in original post

3 Replies
Highlighted
Specialist II
Specialist II

how about using concatenate

View solution in original post

Highlighted
Partner
Partner

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

Thanks!

Highlighted
Digital Support
Digital Support

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

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.