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?
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.
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.
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. 😃