SOLVED
Copy Paste or Append as per column name
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
salmansadatkarim
5 - Atom
‎11-23-2024
03:14 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi, I am new in Alteryx and just wanted to know if the following is doable in Alteryx.
I have an Excel sheet with the following columns and values
Table-1
Srl No | Customer Name | Customer No | Business Segment | Activity |
1 | ABC Company | 001-123456 | Multi National | Active |
2 | DEF Company | 001-789123 | SME | Inactive |
3 | GHI Company | 001-456789 | Corporate | Active |
I want to add the following in the first table
Table-2
Srl No | Customer Name | Customer No | RM Name | Business Segment | Activity |
1 | JKL Company | 002-123456 | Ruby | International | Active |
2 | MNO Company | 002-789123 | John | Large Business | Active |
3 | PQR Company | 003-456789 | Amy | Sole Prop | Active |
So the output becomes like the following. Please note, I need to be able to pick only the relevant columns from Table-2.
Table-3
Srl No | Customer Name | Customer No | Business Segment | Activity |
1 | ABC Company | 001-123456 | Multi National | Active |
2 | DEF Company | 001-789123 | SME | Inactive |
3 | GHI Company | 001-456789 | Corporate | Active |
4 | JKL Company | 002-123456 | International | Active |
5 | MNO Company | 002-789123 | Large Business | Active |
6 | PQR Company | 003-456789 | Sole Prop | Active |
Thanks in advance.
-Salman
Solved! Go to Solution.
Labels:
- Labels:
- Help
2 REPLIES 2
MelGibson
10 - Fireball
‎11-25-2024
08:08 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎11-25-2024
09:16 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank You so much for taking time and providing this solution! This worked perfectly. Thank You!
![](/skins/images/2A479D0ADEFDAA8078B5B9F489A80DDD/responsive_peak/images/icon_anonymous_message.png)