Importing data from Excel - formatting decimals



I have downloaded new version of Pyramid Analytics and would like to make some visuals for a test. My initial inquiry got stuck in the phase of loading data from Excel. My Excel file has decimals separated as comma (","), however Pyramid imports commas as thousands separator and converts them to points ("."). How can I change number formatting in Pyramid, so that the formatting from Excel will be kept also in Pyramid?

1 reply

    • Carrie_Nielsen
    • 5 yrs ago
    • Reported - view

    Hi Uros,

    You can leverage setting a datatype on the column value by double clicking on the appropriate select statement and opening the column selection on the right side of the screen.  Give that a try, otherwise if you have a test file you can upload I will take a look.



Content aside

  • Status Answered
  • 5 yrs agoLast active
  • 1Replies
  • 135Views
  • 2 Following