Forum Discussion
help with volume based on multiple columns
Hello everyone I have a CSV file that lists one order per row, however, each order could potentially be worked on by multiple vendors. The vendor columns are listed vendor 1, vendor 2, vendor 3, ...
Anonymous here is another approach where we split vendor and result in two different tables to avoid pivoting and then with the relationship we can achieve the result.
Anonymous well unpivot should be quick but pivoting is slow, I do pivot it back to get the vendor and the other column on the same row, if you don't need that, just simply vendor then you can remove those extra steps after unpivot and it should be quicker. so not sure if you need that or not