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

MultiField Formula

Riot
8 - Asteroid

I have a list of fields and I want to change the information in them. What I am trying to do is 

 

IF [_CurrentField_] = 1 THEN 1
ELSEIF [_CurrentField_] = 2 THEN 1.08
ELSEIF [_CurrentField_] = 3 THEN 2.6
ELSEIF [_CurrentField_] = 4 THEN 3.4
ELSEIF [_CurrentField_] = 5 THEN 4.2
ELSEIF [_CurrentField_] = 6 THEN 5
ELSE [_CurrentField_]
ENDIF

 

But that didnt seem to change the fields I selected. They stayed the same. 

Any ideas ? I imagine i am doing it wrong. 

3 REPLIES 3
MarqueeCrew
20 - Arcturus
20 - Arcturus

I do assume that you are using a multi-field formula and that you've selected numeric fields.

 

Depending upon your alteryx version, you might need to change '=' to '=='.

 

You might also try:

 

Switch([_CurrentField_]),[_CurrentField_],1,1,2,1.08,3,2.6,4,3.4,5,4.2,6,5)

 

Thanks,

 

Mark

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
tom_montpool
12 - Quasar

Make sure that you turn off the "Copy Output Fields and Add [New_] as a {Prefix}" option.

 

In my opinion, this should be in the running for "Worst....Default....Ever"!!!

 

Have fun!

Riot
8 - Asteroid

I switched my output from INT16 to Float because INT16 was rounding up to the nearest whole number. Can I change that or should I just use a float ? 

Labels