Hello everyone,
First-time, long-time...
I have a table that contains two Values (that would go in the Value field in a visual). I want them to be in the same column, and I can differentiate between them using another column and the attribute in that column.
Naturally I used Unpivot Columns. This works fine, except the refresh rate (Oracle connection) went from thousands of rows per second to TENS of rows per second. I have millions of rows, so this is not practical.
My next best option was to separate the table into two tables. I first duplicated my table, then prepared each resultant table accordingly, and Appended one to the other. All column names and order are identical in both tables. This too is taking FOREVER. I do not understand why that would be.
For Unpivot I understand why it would reduce performance. For Append though, I don't get it.
I then tried to do all my data prep on the table, then reference the table into a new query, Table.Buffer it, THEN Unpivot, thinking this would Unpivot as a local operation, but when I Close&Apply, the data load is from the Oracle source and is still very, very slow.
Any ideas?
