Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
Start Free Trial

Alteryx Designer Desktop Discussions

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

How to create a correct formula dealing with 2 separate columns?

maddoxs
7 - Meteor

Is there a way that I can create a formula that shows if [Line of Business] = ""RR" than [Invoice Line Type] can be changed to say Rental Equipment? 

maddoxs_0-1662066187161.png

 

3 REPLIES 3
FrederikE
13 - Pulsar

Hey @maddoxs,

I think

 

IF [Line of Business] = "RR"

THEN "Rental Equipment"

ELSE [Invoice Line Type] 

ENDIF

 

with the target column Invoice Line Type

 

is what you are looking for. 

prpatel
11 - Bolide

Yes.

Use a formula tool.  For the Output column select [Invoice Line Type]

 

Your formula will be

 

if

[Line of Business] ='RR'

then

"Rental Equipment'

else

[Invoice Line Type[

endif

 

try that.

 

-prpatel.

Emmanuel_G
13 - Pulsar

Hi @maddoxs ,

 

Yes it is possible. Find a workflow attached with sample of your dataset to resolve this issue.

 

You can add this tool directly to your workflow. 

 

Let me know if there is any issue. 😃

 

Emmanuel_G_0-1662506380196.png

 

Labels
Top Solution Authors