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:
      LOAD

      Product_ID,

      [Hong Kong] as Price,
      'hk'
      as POS

      FROM
      [C:\Users\jforeman\Downloads\Temp\2012-03\productpricing.xlsx]
      (
      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?