Struggling to get this set up properly.
I have three files that feed a consolidation.
All have a date column.
If I apply a query to order by date in asc or desc, it's only applied to each file but not the entire consolidation.
Meaning my entire consolidation is not ordered by date as desired but only its sub-pieces.
Can this be fixed somehow?