June 7, 2022
I have a transaction log where I want to combine the rows who have the same ID and Time stamp. In the attached file a have put an example.
Is this possible in a query?
January 31, 2022
Please see attached. Once you have connected to the table and set the correct data type to Time for the time column, you can group by ID and Time. Please refer to the attached file.
Note: The query in the attached file was made with PQ for the Mac. A little bit different than the PC version, but very similar.