Qlik Community

Ask a Question

New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Announcements
Do More with Qlik - for Beginners and Beyond, Topic: Qlik Replicate on January 21, 2PM EST. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Specialist II
Specialist II

how about using concatenate

View solution in original post

3 Replies
Specialist II
Specialist II

how about using concatenate

View solution in original post

Partner
Partner

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

Thanks!

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.