Formula on Multiple Inputs
- 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
Hi!
I am trying to create a formula using 2 inputs.
Input no1 - Merival + ZEUS values
Input no2 - External ID + ACU/DBU Ctr
I wanted to use the following formula - If [Merival] = [ACU/DBU Ctr] and ZEUS = [External Id] then "MV Match" ELSEIF Zeus = [ACU/DBU Ctr] and [Merival] = [External Id] then "Zeus Match" else "no match" endif
The above will tell me whether Merival matches with ACU & ZEUS with External ID or vice versa.
Any idea how this can be done?
Thanks!
Solved! Go to Solution.
- Labels:
- Workflow
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @emiafshar
I think maybe you're pointing out to a wrong approach for this situation
You could try to join your inputs first, so you can compare your records on a row-to-row basis.
Add a Record ID to both of your inputs
1st step:
Join your inputs with these conditions:
[Merival] = [ACU/DBU Ctr]
ZEUS = [External Id]
2nd step:
Join them again with these conditions:
Zeus = [ACU/DBU Ctr]
[Merival] = [External Id]
3rd step:
Union the Join Outputs of the two steps before with the L and R Outputs of them.
4th step:
Get rid of the possible duplicate values, using Unique Tool and selecting Unique Record ID_1 and Record ID_2.
5th step:
Use Formula to apply your Table Match condition.
It might go this way, maybe with some things to adapt to, but if you could share your data it would be easier to validate this.
Cheers,
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
What if those two inputs does not have a primary condition to join? and two different files
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello! I´m having the same issue, could you solved it?
