Getting the error while processing multi xml data

[ShruthiVijayaKumar]

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

[OTrieger]

@ShruthiVijayaKumar 

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

[alexnajm]

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]

@ShruthiVijayaKumar #

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

[ShruthiVijayaKumar]

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

[ShruthiVijayaKumar]

Its bit urgent can you please help

[alexnajm]

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

[ShruthiVijayaKumar]

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]

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

[ShruthiVijayaKumar]

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