If Statement based on column
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
Solved! Go to Solution.
- Labels:
- Developer
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
LOL @NicholasM beat me to it with pretty much the same workflow
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you for all the correct answers, I have multiple ways to solve my issue.
