3 Replies Latest reply: Mar 26, 2012 4:53 AM by Henric Cronström RSS

    Efficient ways to load data that is in the wrong format?

      I've got a file which has Product ID as the key, and then a series of columns, each one showing the price of that product in a different country.
      What I'd like to do is have the price of the product as a dimension, as well as the country and Product ID. Currently I do this:


      [Hong Kong] as Price,
      as POS

      ooxml, embedded labels, table is productpricing0);
      but I'm concerned that's not the best way to do it (there's about 100,000 rows in the file, and 20 different countries, so it's a bit of a challenge for my computer).  Any suggestions?