Forum Discussion
Most efficient way of sorting rows
Hi SjoerdV
I'm not clear with the following:
Which data source do you connect to? folder or excel files?
from your simplified example,i can't see any date/time column, so I wonder how do you create a chronological order of files per trailer?
For this :
allocate the costs made on File Number 266 and 571 to File number 244. I do this by sorting in Power Query on Trailer, and then on 2 time/date-fields
I can't reproduce it on my site, maybe there is misunderstanding for it.
as i understood, I can click on the Trailer column and select "sort ascending", then the same for two "time/date" columns, but how does this behaviour allocate the costs made on File Number 266 and 571 to File number 244?
Additionaly, If you sort in Data model view, you can sort one column by another column.
Best Regards
Maggie
v-juanli-msft Thank you very much for your reply.
Answers to your questions;
Which data source do you connect to? folder or excel files? >> Two CSV-files.
from your simplified example,i can't see any date/time column >> There are multiple time-date columns I use to sort on, just not added them to to example in order to keep it simple.
I can click on the Trailer column and select "sort ascending", then the same for two "time/date" columns, but how does this behaviour allocate the costs made on File Number 266 and 571 to File number 244? > The result of ordering chronologically results in a table, which I then determine, after some other checks, to allocate costs made on FileType B and C to a specific file with FileType A.
