Formula Question

[bliffick]

Hello All,  

I have searched for this answer but I cannot find a specific one.  I am currnetly writting a failry large formula and want to break it up into smaller easier to read segments.  If I put all the data in one formula it works in my output, but IF I seperate them, none of the Formulas work, except for the first one.  All of the data is going to be written to the same column for each portion.  

Is this possible, or do I need everything to go into one big formula?

[ChrisTX]

It is possible to break up a large formula into smaller segments.  For each segment, are you using the correct output data type?

Chris

[bliffick]

I am not sure I understand your question, I am new to Alteryx.  

[apathetichell]

use text input tool. create a matrix of values.

make sure your formats match.

use a join tool.

[Qiu]

@bliffick 
It is my experience, wer are not doing it correctly if we are writting long conditional statement 😁
if you can eloborate your question with sample input and output date, I am sure someone can help.

[caltang]

That's a very long IF statement. Do you mind providing some raw data? Also what do you exptect? A simpler expressio or...?

[caltang]

Better still, since you're already using Alteryx - you could export this workflow over here if it's possible.

To export a workflow go to: Options > Export Workflow. Kindly do NOT send a "Save As" copy.

[ChrisTX]

The syntax for your Contains function is not correct:  

  elseif StartsWith([05], "Microsoft windows 10") and Contains([05_Version], "17763" or "18363" or "14393") Then "windows 10"

You can't use "or" inside a Contains function.

The correct syntax is:

  elseif StartsWith([05], "Microsoft windows 10") and (Contains([05_Version], "17763") or Contains([05_Version], "18363") or Contains([05_Version], "14393")) Then "windows 10"

Here's the list of Functions:  https://help.alteryx.com/current/en/designer/functions.html

Chris

[bliffick]

The reason for the long if statement is I am sorting a large amount of Operating systems, and trying to have the formula catergorize them, instead of me copy pasting a ton through the next week.  My question boils down to, why when I break out portios of the If statement (into their own container) why does the entire IF statement stop functioning.  I have the formula set to VWString, which is what the incoming data is.