Forum Discussion
Creating a lookup table
michaelh121 So you use 3 fact tables.
Try to avoid two way relantionships.
You have multiple options depending the info your columns have in tables.
Best is to try data modelling in Query mode.
If you have all the site codes in one table you can right click the query/table and reference - > Select the Site codes column -> remove other columns -> Remove duplicates - Ready
* Keep in mind that Query treats capital & lower case letters as different while when loaded model will show an error as it treats as the same letter.
If the Site codes are scattered in all tables then repeat the proccess for each query and the merge append all and again remove duplicates.
Hi Matt,
My tables have multiple columns(about 20-30 per table), I can't show these columns beucase it is sensitive data.
That's the reason why I try to create a lookup is because I can't join these tables into one big table.
As I mentioned earlier, each table has the columns "Site Code" but 4 out of 5 table have duplicate entries in them and only one has unique values. What I want to do is to have a lookup that will reference back to those tables and pick all the site codes hence don't use the column "Site Code" from each table but just use the lookup table for it, I also hope that this will allow me to create cross-table visuals as I can't do this at the moment.