Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Writing numeric data to Oracle does not work

MichalK
8 - Asteroid

Hi,

 

I have a workflow that writes data into an existing table in Oracle database.

One of my fields contains a numeric value (set to 'Int32' type in Alteryx), and I'm writing it to an Oracle field set up as 'Number' type. Unfortunately, when I run the workflow the number field is populated with an empty value. I'm using 'Write Data In-DB' tool to write into DB.

 

Any tips on which Alteryx format to use and what may be the cause for this?

 

Thanks,

Michal

3 REPLIES 3
JoeS
Alteryx Alumni (Retired)

Hi @MichalK

 

If you read from that table, what data type is that field?

The driver should be able to map things for you, but if you make sure you set it to the same that's it's read as then hopefully that will fix the error for you.

 

Thanks

Joe

MichalK
8 - Asteroid

I found the bug - it had nothing to do with formatting, I had some trailing whitespace in the field name...

JoeS
Alteryx Alumni (Retired)

Ah, glad you got to the bottom of it!

Labels