Reply To: Combining Historical CSV with Current Data

Optuma Forums Optuma General Discussion Combining Historical CSV with Current Data Reply To: Combining Historical CSV with Current Data

#66371
Matthew
  • Topics: 5
  • Replies: 481
  • Posts: 486

Hi,

The Optuma cache files are not raw text / XML, currently there is no way to add extra data to Optuma cache files using CSV as a source.

With the Dow, Optuma does support pre 1900 dates.  It can be difficult to setup as Excel doesn’t format pre 1900 dates the same way as normal dates. You may need to use the Text to Columns process in Excel to force the column to be detected as a date.

https://support.microsoft.com/en-us/office/split-text-into-different-columns-with-the-convert-text-to-columns-wizard-30b14928-5550-41f5-97ca-7a3e9c363ed7

1 user thanked author for this post.

Pin It on Pinterest