How to match multiple rows to values in columns from another file?
- 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 all, i am trying to match multiple rows in Table1 to Table2 values in columns from another file. Also in the end i would like to add a column of sum of those values for that row like in Table3.
Table1:
A | B | C |
ABC | CDF | EFG |
ABD | CDE | EFH |
ABC | CDK | EFH |
Table2:
ABC | 1 |
ABD | 5 |
CDF | 10 |
CDE | 20 |
CDK | 5 |
EFG | 3 |
EFH | 5 |
Table3:
A | B | C | Sum |
ABC | CDF | EFG | 13 |
ABD | CDE | EFH | 30 |
ABC | CDK | EFH | 11 |
Thanks in advance!
Solved! Go to Solution.
- Labels:
- Best Practices
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello @vmadyala ,
Here you have:
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Regards
- 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
Perfect!....thanks for your help.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I have another question. Now, i want to add a fixed number, let's say 10, across sum_field columns and i want that fixed number input to be dynamic for example i should be able to input a different number each time i run. Could you please help?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello @vmadyala,
yes, you can indeed. You just need to add a constant to the workflow:
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Regards
