9 Replies Latest reply on Sep 17, 2013 11:31 AM by Alex Kerin

    CSV Data "1.0.7" is imported as "-2"

    Felix Kubasch

      See following example of my CSV source file:

      idproviderproviderCountryskudevelopertitleversionproductTypeIdunitsdeveloperProceedsbeginDateendDatecustomerCurrencycountryCodecurrencyOfProceedsappleIdentifiercustomerPricepromoCodeparentIdentifiersubscriptionperiod
      1APPLEUS1001My CompMy App1.0.71F3010/28/1210/28/12EURNLEUR5067068500

       

      I need to import the version field as a STRING. Changing the data format within tableau doesn't work. I receive "-2" as a values instead of "1.0.7", so I tried several approaches using the Custom SQL at the data connection level.
      e.g.

      STR([myfile#csv].[version]) AS [version]

      returns "12:00:00 AM" --> still not what I want.

       

      Any ideas?

      p.s. Unfortunately I have to accept the given CSV format. There is NO way change this upfront, sorry.

       

      Attached the CSV.