I have two inputs:
Input A
Country | Fruits | Amount |
USA | Apple | 500 |
USA | Orange | 600 |
India | Banana | 700 |
New Zealand | Kiwi | 800 |
India | Mango | 900 |
Pakistan | Pineapple | 1000 |
Input B
A1 | B1 | C1 |
USA | Created by | Alex |
USA | Posted by | Lia |
USA | Reviewed by | John |
I want to out Input A and B , side-by-side, to different tabs based on Country in common.
So, For example, in my output file, i would have a tab named "USA", with below as my output:
Country | Fruits | Amount | B1 | C1 |
USA | Apple | 500 | Created by | Alex |
USA | Orange | 600 | Posted by | Lia |
Reviewed by | John |
How can I get this?
@aishwarya_baburaj98 the attached workflow demonstrates how this is possible using the "Join by Record Position" configuration in the Join Multiple tool.
Just use input data tool instead of input Text. Then join fields By "Country" and "A1". Enjoy!
User | Count |
---|---|
107 | |
82 | |
70 | |
54 | |
40 |