Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

replace data in a column

Highlighted
6 - Meteoroid

Hi all!

 

I have an ad-hoc to do and I need your help with this step. 

 

I have a column of data in which I need to replace some entries.

Data is like this. A,B,C are all string type names.

 

Col_name

A

null

null

B

 

I want to replace null with C. Please let me know how to do this.

 

Thank you very much for your help.

 

Felix

 

Highlighted
Alteryx Partner

@felix A simple formula should take care of this for you.

 

IFNULL([Col_name], 'C')

jReplace Row.PNG

Highlighted
6 - Meteoroid

Hi John,

 

Sorry for not making this clear.

 

My column is like 

 

A

null

null

B

null

null

D

null

null

 

I want to replace the first two null with C

and leave other nulls as nulls

 

Thanks,

felix

Highlighted
Alteryx Partner

 

This will do it.

 

2018-03-14_00003.png

Highlighted
Alteryx Partner

Here's an alternative method, leveraging Record ID

 

Replace Row v2.PNG

7 - Meteor

Hi John, great and simple explanation.  i successfully used it with the below test formula with the column "ship from" as my output column in the config box:

 

 

IF [SHIP FROM]="FI07A"
THEN "Workd"
ELSE [SHIP FROM] ENDIF

 

 

 

this changed all instances of "FI01A" in the single column "ship from" to "Workd".

 

now the problem I still have:

How to use this to change every instance of "FI01A" in the entire file, every cell in every row and column?

 

i was directed to the Dynamic Replace Tool in another post but none of the examples quite fit my situation.

Highlighted
Alteryx Partner

Hi @Rob48 - Please start a new post so that it'll be easier for folks to find the solution in the future.  It will also help if you could post a sample of the data.  Thanks!

Labels