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.
The Formula tool in Alteryx can not add rows to your data. It can only add new columns or modify existing ones. The duplicate data is either present in the input data or is created as the result of join or union. Check the outputs of the tools before these to find out where the data is being duplicated. It's better to never produce the duplicates in the first place than to have to correct them.
If the data is in this form directly in the input, and you need to correct it, use a Filter to extract all rows where the Product is not empty then apply a Formula tool to change all the [Department Descr] to "Transfer to 70202". You may need to clean the Product column, because it seems to have a space which would count as not empty