Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

replace data in a column

felix
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

 

6 REPLIES 6
john_miller9
11 - Bolide

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

 

IFNULL([Col_name], 'C')

jReplace Row.PNG

felix
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

derekbelyea
12 - Quasar

 

This will do it.

 

2018-03-14_00003.png

john_miller9
11 - Bolide

Here's an alternative method, leveraging Record ID

 

Replace Row v2.PNG

Rob48
8 - Asteroid

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.

john_miller9
11 - Bolide

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