Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying to upload an excel file as a cross tab...using the following code:
CROSSTABLE([Product Category], [Goal Dollars], 2)
LOAD * FROM Datasources\others\NetSalesGoals2010.xls (biff, embedded labels, table is [vLOOKUP $$], filters(
Remove(Col, Pos(Top, 5)),
Remove(Col, Pos(Top, 4)),
Remove(Col, Pos(Top, 3))
));
My excel file has a date, customer, and then products going across the top with $ going down the columns. The problem I am running into is it appears it is only loading the first row of data. So it loads productA, productB, productC, productD...only once each rather than once for each customer in the spreadsheet. Am I missing a step?
Hi Heather,
I'm guessing that you are on an old release of QV 8.5 as this sounds exactly like a bug, 22138, that was around up until 8.50.6299 but was fixed and it's working fine in the latest release, SR6, 8.50.6326. Please upgrade and give it a go.
Hi Heather,
I'm guessing that you are on an old release of QV 8.5 as this sounds exactly like a bug, 22138, that was around up until 8.50.6299 but was fixed and it's working fine in the latest release, SR6, 8.50.6326. Please upgrade and give it a go.