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
@ShruthiVijayaKumar
Control Parameter will only work with String so whatever coming form your Control Parameter is not numeric but string
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
@ShruthiVijayaKumar #
One more thing, normally I will use the connection Q to Q without the Action tool, it makes life easier.
Can you please let me know what formula to be used and how to use it,please.
Its bit urgent can you please help
ToNumber([#1] ) should do the trick…
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.
You haven't changed the action tool to "Update Value with Formula"
I changed that also but still error ,will share image again
You need to also show the error then
Please find the image with changes,but still same.
I don't see an error. Please let us know how this is actually running, or send it over - otherwise we cannot help further
Look fine for me. The Control Parameter is not selected in Designer mode, so when click on Run it seems as if the Filter tool is failing, but it is not. You will need to run the automation out of the macro to see it working.
Ya, have shared the code. Can you please check and update soon
Thanks in advance.
Regards,
Shruthi.V
It doesn't error for me (once I change everything to my computer paths), so again what is the error?
if we process the macro file (yxmc) its fine, but the main solution is not getting an error, but the values are blank in main YXMD solution.not giving out zero records in main solution
You should check that you did not leave in the macro any static data.
You say that when running the macro all fine, check if the variables are still there and not replaced with static value and therefore the macro runs well but not getting the needed values and resulted with no output
ya can you please run the YXMD solution and try to see values in it....i am getting blank values
