Data in Microsoft Excel(NON-ODBC) is converted to scientific format after introspection in TDV

Data in Microsoft Excel(NON-ODBC) is converted to scientific format after introspection in TDV

book

Article ID: KB0082253

calendar_today

Updated On:

Products Versions
TIBCO Data Virtualization -

Description

For instance:
• 993E-00121 in excel is converted to 0 in TDV STUDIO
• 003E- returns a value of 3
• 003E-1 returns a value of .3
 

Issue/Introduction

Data-in-Microsoft-Excel-NON-ODBC-is-converted-to-scientific-format-after-introspection-in-TDV

Resolution

This issue will be resolved in 7.0.5 Hotfix 04.
The workaround is to create the datasource using MS-Excel adapter. (Attached are the detailed instructions)
 

Attachments

Data in Microsoft Excel(NON-ODBC) is converted to scientific format after introspection in TDV get_app
Powered by Wolken Software