Alteryx Designer Desktop Discussions

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

Getting the error while processing multi xml data

ShruthiVijayaKumar
7 - Meteor

Hi Team,

 

We are trying to process the multi-XML data all at once based on node, but we are getting the below error, and these are the setups made below.

 

Error: multiple_xml-ICMSTot (8) Record #1: Tool #6: Numeric fields can only contain numbers

 

 

 

18 REPLIES 18
OTrieger
13 - Pulsar

@ShruthiVijayaKumar 

Control Parameter will only work with String so whatever coming form your Control Parameter is not numeric but string

alexnajm
18 - Pollux
18 - Pollux

Agreed with @OTrieger - so in that case, you will likely have to do "Update Value with Formula" in your Action tool and change the data type for use

OTrieger
13 - Pulsar

@ShruthiVijayaKumar #

One more thing, normally I will use the connection Q to Q without the Action tool, it makes life easier. 

ShruthiVijayaKumar
7 - Meteor

Can you please let me know what formula to be used and how to use it,please.

ShruthiVijayaKumar
7 - Meteor

Its bit urgent can you please help

alexnajm
18 - Pollux
18 - Pollux

ToNumber([#1] ) should do the trick…

ShruthiVijayaKumar
7 - Meteor

Hi  alexnajm,

 

Can you please let us know where we have to change the formula,have attached the image ,please can you confirm on the image step to be changed.

alexnajm
18 - Pollux
18 - Pollux

You haven't changed the action tool to "Update Value with Formula" 

ShruthiVijayaKumar
7 - Meteor

I changed that also but still error ,will share image again

 

Labels
Top Solution Authors