Tool to Edit Individual Cells

Hi All,

I am very new to Alteryx. I have built a flow (Thanks to the help of a user several months ago!) to compare multiple different spreadsheets in which the input date is all from different systems. What I am stuck on now is finding a tool that will let me change actual cell data. For Example, 1 of these systems uses a label of BARX while the other system uses a label of BRS. I would like to edit the input sheet that uses BARX and change it to BRS in every single instance. I have multiple label differences, so with the comparison workflow I've built I always have a difference because of the labels, but the data is the exact same. To make it easier to read and only spot actual differences in the 2 datasets, I would like to change the labels with a tool if that is possible.

Hopefully I have explained this well enough. Apologies in advance if I have not as again I am very, very new to Alteryx.

Thank you!

Workflow

Accepted answers

T_Willins

Hi @jmmart08,

You can use an IF/THEN/ELSEIF formula:

IF [Field1] = "BARX" THEN "BRS" ELSEIF [Field1] = "USBX" THEN "USS" ELSE [Field1] ENDIF

For additional changes, you just add more ELSEIF ... THEN to this formula. For changing other fields (columns), you can use the same Formula tool, just add a new formula (+ below where you see data type), select the next column, then repeat this process. I attached a sample workflow for your reference.

If this works and answers your question, please mark this as an accepted solution to let the Community know your question has been answered.

IF Statement Formulas.yxmd

All comments

T_Willins

Hi @jmmart08,

Does "BARX" show up in a field? If it does, it can be replaced using a Formula tool. For instance, if it is in Field1, then in the Formula tool Select Column Field1, then use the following formula: IF [Field1] = "BARX" THEN "BRS" ELSE [Field1] ENDIF

If this is not fitting your use case, please provide sample data and examples of what you are trying to do.

jmmart08

Hi T_Willins,

Thank you very much for your reply. This does work but I have several other cases like this within the same column, and in other columns. Would I have to place a formula tool in my workflow for each instance or is there a way I can do this in 1 formula tool? Another example is within the same Column, I need to replace the text "USBW" with "USS". I believe I have 4 different find/replace I need to perform within this same column, and also do something similar in 3 other columns.

Quick Links

This months top contributors

FláviaB 262

JORGE4900 235

caltang 177

DanM 167

IraWatt 157