If Statement based on column

Question

Hello Community!

I have a constraint. I have several columns where I need to reference a portion of the text in one to determine the value to put in another or possibly a new field.

Simply put, in the attached Excel, if Camry has "Awaiting" in the field I would like to be able to add the name from Camry Approver.

Is this possible?

Thanks in advance

Alteryx Grouping Example.yxmd

Alteryx Grouping Example.xlsx

NicholasM · Accepted Answer

Hey @ZoeM ,

I think you are very close. The tool I would recommend for a join on two or more fields is the "Join" Tool. In your case, I think some more clean up on the Approver data stream is necessary. I have attached a workflow of how I would attack the join.

Let me know if you have any questions.

BrandonB · Accepted Answer

Here you go! Workflow attached.

kelsey_kincaid · Accepted Answer

Hi @ZoeM , there are several ways to accomplish this. I've attached an example below. I'd recommend performing a cross tab on every field, grouped by product rather than excluding the approvers. After that you can join your dataset with itself and run a formula to accomplish what you are looking for.

MinaGO3 · Accepted Answer

Everyone has already posted a solution but I figure one more can't hurt since I already built it. This one has a cross tab or summarised view.