Forum Discussion

Rolf's avatar
Rolf
Frequent Visitor
8 years ago
Solved

Create a new table with last known record

Hey,   I have a table with many records of equipment and where it has been. I would like to take this data to another table and keep only te most recent entry (row) of each equipment.   I have tr...
Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    Hi Rolf

    Sorry for getting back late. In Power Query, you can achieve exactly the same reults

    1) Create a duplicate table/query
    2) Use the "Group by" ....... Group by Equipment.......New Column with Maximum Date
    3) Then Go to Merge Queries (merge the above table with orginal table)
    4) Select Date and Equipment Columns in both tables (Two Column match)
    5) Expand Table Selecting LAT and LON


     

Zubair_Muhammad's avatar
Zubair_Muhammad
Icon for Community Champion rankCommunity Champion
8 years ago

I think so it can be done using Merge Queries in Power Query.

Have got to leave. Will get back to you on this

Zubair_Muhammad's avatar
Zubair_Muhammad
Icon for Community Champion rankCommunity Champion
8 years ago

Hi Rolf

Sorry for getting back late. In Power Query, you can achieve exactly the same reults

1) Create a duplicate table/query
2) Use the "Group by" ....... Group by Equipment.......New Column with Maximum Date
3) Then Go to Merge Queries (merge the above table with orginal table)
4) Select Date and Equipment Columns in both tables (Two Column match)
5) Expand Table Selecting LAT and LON


 

  • Rolf's avatar
    Rolf
    Frequent Visitor
    8 years ago

    Was worth the wait ;) This is exactly what i needed. Thank you very much. I had the same issue with duplicates but just added a remove duplicate step which gives me an excellent unique list of last known location.