This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Inspire EMEA 2022 On-Demand is live! Watch now, and be sure to save the date for Inspire 2023 in Las Vegas next May.
We'll be completing standard maintenance for our Single Sign-On system on November 30th 6pm Pacific Time for approximately one hour. During this time My Alteryx and sign-in functionality to all My Alteryx programs (Licensing Portal, Community, Beta Program, Case Portal, and others) may be inaccessible. Thank you for your patience.
I am working with a set of data that I need to concatenate into one field in the form of a sentence - I have been successfully able to concatenate this data using formulas, but I am running into an issue with one of our formatting requirements. The data elements must be separated out by commas for the most part, except for the last delimiter which must take the form of " and ". Please see below for examples of what I have and what I need.
Ex. Current - bank account number,credit card number,address
Ex. Needed - bank account number,credit card number and address.
I had the idea to attempt to use the below formula in the formula tool to achieve this (where "Summary" is my concatenated field, but I am receiving the below error when i try this. Any help would be greatly appreciated!
Formula : Left([Summary], Length([Summary]-FindString(ReverseString([Summary]),","))+" and "+Right([Summary], Length([Summary]-FindString([Summary], " and "))))
Error: "Formula: invalid type in subtraction operator"