Hi all!
I was just wondering why one of my formulas (30), specifically expression #11, is returning only [Null].
This happens even when I put the most basic formula in, such as [Task On].
I have posted my workflow below.
Thank you in advance!
So the issue is definitely data types.
Here's a quick interactive lesson about data types from Alteryx that might help if you're not sure what these things are:
https://community.alteryx.com/t5/Interactive-Lessons/Understanding-Data-Types/ta-p/73958 (If the link doesn't work, mouse over 'Academy' on the left hand side, then click Interactive Lessons.
If you already are familiar, then I would look at Select (11) and see what the data types are for [Task On] and [Reqs Date]. On my screen [Task On] is a date and [Reqs date] is a Double. I would use a DateTime tool from the Parse menu to change [Reqs Date] to a date and then change the formulas in Formula (30) to account for this change.
Basically Alteryx is being asked to run formulas designed for dates on fields that it isn't sure are dates. Once the conversion error limit is reached it stops trying and returns Nulls.
Thanks,Ken
Yes, @kgalbert is right on the money. Alteryx only accepts dates in the following format: yyyy-mm-dd.
You could add a DateTime tool to the start of your workflow (as long as no other tools depend on the current date format you have) to fix this, and set the "Select the format that matches the incoming string field" configuration to: MM/dd/yyyy.
You'll then have a new field called DateTime_Out (unless you rename it), which you can apply your formula to later on and avoid these coercion issues.
Cheers!
Have you tried changing the type of the field? I notice that its a V_String, and I'm not sure if this would apply here, but I've had some weird conversion errors result in NULL values in cases where the type of the new field doesn't play well (match, or easily coerce types) with the one I'm calling using the expression.
Since you haven't obtained any sample data to work with, I'm unable to try and work out a solution. If you could upload a sample dataset I could try and diagnose this more.
Hi tcroberts!
Thank you for the response.
As you suggested, I've attached a sample dataset below.
Thank you again for the help and please message me if you need any extra info.
