Formulat Try It Solved - Third Question in AX Academy

[sbb]

https://community.alteryx.com/t5/Learning-Paths/Getting-Started-Learning-Path/ta-p/475117#done

It says to use the "Using the countwords() and getword() function, create a new column named 'Suffix' that contains the address suffix (DR, WAY, ST)" to answer the problem. I'm not clear on why the countwords() function would be used. 

[AbhilashR · Accepted solution]

Hi @sbb, as the name of the function indicates, the countword() function helps you identify the number of words in a given record. Once you know the number of words, you use the getword() function to fetch the 'Suffix' words in this case. Just note that the getword() function starts with an index of 0 while you attempt to solve this question.