Forum Discussion

lukasjar's avatar
lukasjar
Resolver I
6 years ago

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 ...
Need Help
lukasjar's avatar
lukasjar
Resolver I
6 years ago

The combined table is done in the same way being: Merge new query, Left Anti and remove all columns but Location?

And how is the distinct done?

 

artemus's avatar
artemus
Microsoft Employee
6 years ago

1. Yes, remove all columns but location.

 

2. Click the column and choose: Remove Rows -> Duplicates

  • lukasjar's avatar
    lukasjar
    Resolver I
    6 years ago

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