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

create new field when there is null/empty value

umairah
8 - Asteroid

So I want to separate data from a field to new field for example:

1 Singapore 45.9

1 Indonesia 60.2

2 Brazil 50.2

2 Mexico 40.7

3 United Kingdom 35.8

3 Australia 53.0

 

 

1 Brazil 48.7

1 Australia 58.1

2 United Kingdom 53.5

2 Indonesia 43.9

3 Singapore 40.3

3 Mexico 48.3

 

This is what I want to achieve. Whenever the value is null/empty it will create a new field.

1 Singapore 45.9

1 Brazil 48.7

1 Indonesia 60.2

1 Australia 58.1

2 Brazil 50.2

2 United Kingdom 53.5

2 Mexico 40.7

2 Indonesia 43.9

3 United Kingdom 35.8

3 Singapore 40.3

3 Australia 53.0

3 Mexico 48.3

 

Is it possible? Any help is really appreciated.

1 REPLY 1
grazitti_sapna
17 - Castor

Hi @umairah , try this if it works for you.

grazitti_sapna_0-1600057938052.png

 

If this is what you are looking for kindly mark this post as solution and give it a like.

Thanks.

 

Sapna Gupta
Labels