If expression locked to 64 characters?

[Saarek]

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

[MarqueeCrew]

@Saarek,

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

[Saarek]

Hi Mark,

Each of the inputs are set as VW String, none of them individually current exceed 64 characters.

[MarqueeCrew · Accepted solution]

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.

[Saarek]

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.

[MarqueeCrew]

@Saarek,

I am sending you an alternative way of computing the reason field.  Please note that the field has a huge potential width.

Cheers,

Mark

[Saarek]

Thanks for the upload, I'll study it and learn from it.