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.
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.