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 ok then pivot is going to be painful. what is your data source?
parry2k It is a folder with 4 of the same types of CSV files combined (just different time periods). Unfortunately I cannot share it as it is proprietary. The CSV files come from a source provider for ours so we have no control over them but they are nastily built. Yes, I do not think pivoting them back is going to happen, my load seems to be stuck now. Any other ideas? You've been so helpful so far!