AvoidingSyntheticKeyAndLoop.md

Avoiding Synthetic Key and Loop

1. Rename
2. Remove
3. Qualify
4. Concat Key Check 'Using a Key' on 07_LinkTables_Join. Has the issue that you can not see budget by year if year does not have values on sales
5. Join
6. Concatenate Check 'Concatenate' on 07_LinkTables_Join. create one table to merge sales and budget. Issue: brings duplicate rows one set with values on budget and empty sales and vice versa.s
7. Link Table