Forum Discussion
Manual Query, if no match = other
Hello community. I have two different sources with [location] and [location2] with different amount of distinct values that i add in a relationship in MachineId. As you can see below there are just ...
1. Yes, remove all columns but location.
2. Click the column and choose: Remove Rows -> Duplicates
I did not get it to work that way. However I tried doing it this way and got it to work at this time.
1. Renamed column Location2 in MachineHours to Location
2. New Append queries on ScrapData and MachineHours
3. Removed other columns then Location in the new Appended Query.
4. Removed duplicates on the new Appeneded query Location.
5. Can now link ScrapData, MachineHours and MachineId to the new Table.
One issue remains doing it this way is that I have not automated renaming or adding a column with same name or for all of the Locations that are not in my MachineId table as "Other".