GitHub user ossDataEngineer added a comment to the discussion: How to trim numerical strings as per database column precision
@hansva - I tried using select values shape to convert string to number with precision and rounding down <img width="3332" height="931" alt="image" src="https://github.com/user-attachments/assets/d925b096-5843-4ba4-bd5d-e771b8e03ea9"; /> Seems like Oracle table still tries to round up the values. Preview data on select values shape shows correct rounded down data, but ultimately Oracle table gets it rounded up. But when I add one more select values shape with string datatype reconversion, the data in oracle table gets trimmed to precision. <img width="3319" height="928" alt="image" src="https://github.com/user-attachments/assets/128717f0-7cad-4236-80ee-141714ddb84f"; /> <img width="1492" height="387" alt="image" src="https://github.com/user-attachments/assets/1798b52b-af08-4c7d-8a6c-99c101bacd20"; /> Question: Do you see any problems with this approach where I use 2 select values shape? GitHub link: https://github.com/apache/hop/discussions/6291#discussioncomment-15415313 ---- This is an automatically sent email for [email protected]. To unsubscribe, please send an email to: [email protected]
