community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE

Decimal points from source data lost in translation

Atom

When pulling input data from an Oracle data base, decimal points used in quantity data are not being carried over and display the values as whole numbers (i.e. 19.6 comes over as 196). 

 

Is there a way to fix this? 

 

Thanks

Alteryx Certified Partner
Alteryx Certified Partner
Atom

Thanks, but this refers to exporting data.  My issue is importing data and losing the decimal points from the source (JDE E1).

Alteryx Certified Partner
Alteryx Certified Partner

Right I understand that but could you right a pre SQL statement in a similar fashion?

Labels