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.
I am looking for a solution for the following issue:
Currently I have an excel formula that looks at a column labeled "Document Number" and compares one document number to others to see if there are duplicates. If there are duplicates the formula populates the column "Unique Values?" with a 1 and if the document number is not listed more than once than it is assigned a 0.
Is there a way to recreate this formula in Alteryx formula tool?
The easiest way may be to use a Summarize tool with the action Count Distinct on your Document Number field. Then you could use a Formula tool to set a new field value to 0 or 1, based on the value in the Count Distinct column.
Also take a look at the Unique tool under the Preparation palette, and Only Unique from the CReW macro pack.