I have a relatively simple formula, but there is almost certainly a better way to achieve my end result.
The formula, pasted below, works as expected apart from the fact that the output only exports to a maximum of 64 characters.
Around 20% of my results will be higher than 64 characters and so I find the output frequently cuts off the data. As the fields are set to VWString the character limit should be in the thousands and so I am confused as to why this formula will only output a maximum of 64 characters, any ideas?
if [Referral Reason Count] = "1" then [Referral Reason] elseif [Referral Reason Count] = "2" then [Referral Reason] + ", " + [Input_#2_Referral Reason] elseif [Referral Reason Count] = "3" then [Referral Reason] + ", " + [Input_#2_Referral Reason] + ", " + [Input_#3_Referral Reason] elseif [Referral Reason Count] = "4" then [Referral Reason] + ", " + [Input_#2_Referral Reason] + ", " + [Input_#3_Referral Reason] + ", " + [Input_#4_Referral Reason] elseif [Referral Reason Count] = "5" then [Referral Reason] + ", " + [Input_#2_Referral Reason] + ", " + [Input_#3_Referral Reason] + ", " + [Input_#4_Referral Reason] + ", " + [Input_#5_Referral Reason] else "" endif
Solved! Go to Solution.
Please check the data type definition for this new field and make sure that it is also a VWString with a length greater than 64 bytes.
Cheers,
Mark
Hi Mark,
Each of the inputs are set as VW String, none of them individually current exceed 64 characters.
yes, but could you take a screenshot of the configuration tool for the formula that you're writing. This is potentially a new field [All the reasons] where you define that field as 64 bytes long.
So simple, you were right it had limitted the new field to 64. I assume dAlteryx would automatically set the limit to the maximum, still quite new to the application.
Thank you for your help.
Thanks for the upload, I'll study it and learn from it.