Hi all 🙂
Thanks very much for your suggestions - however, I think I may need to handle this in a unique way....
Since the carriage return comes through into Alteryx as a new row in the input, I may need to be creative to wrap up and combine the affected rows.
Here is my test:
I used multi-row formula, and then filtered out the affected erroneous rows.
However, I'm not too keen on the idea of hard-coding in the formula to look for (Honours) specifically.
I'm thinking I can change my formula to:
if IsNull([Row+1:instcscd]) then [instcdsc]+[Row+1:course] else [instcdsc] endif
What do you guys think? Is there a better way to handle this situation do you think?