Hello. I am using Analytics Platform 4.1.3, and I have a question about adding a workflow variable to a table.
I have created a workflow variable max_limit of type double. Created through “Workflow Variable Administration” so that it is available to all the nodes at any moment. Now I need to use that variable, and so I want to add it to my table.
I try to use the “Constant Value Column” with my variable max_limit as “Value setting”:
But if I chose the new column to be of type double (as my variable max_limit is of type double), I get an error saying “Error on creating ‘Number (double)’ from input string: ‘’”. However, if I set the new column type to string, I get no error and a new column with the variable max_limit value in it, but of type string.
Am I not understanding how “Use Variable” option is supposed to work in the “Constant Value Column” node?
In addition - is there a cleaner way to add a workflow variable to a table? I managed to do that with the “Rule Engine” node, but I thought that “Constant Value Column” was a more logical option. Perhaps there’s another way I haven’t thought of?