Interesting approach.
I do have some merges and sorts in the model. For reordering, are you talking about the column order? I try to keep...
In order to get a speed test of a block of code I create a query that performs just the steps I want to analyze, make sure it loads to a worksheet or...
Ken Puls Today, 06:00 PMThat was what I suspected - thanks for verifying!
Now I just have to figure out why my report (45c x 3500r) takes so long to parse.
...
i didn't see the option to edit my post
are you also able to help with my question or just policing?...
Datasource: XLS(x) vs CSV?
Yep, that's the type of of ordering I'm talking about. Personally, I never re-order columns as I always load data to the data model anyway.
Ken Puls Today, 10:24 PM...