Matching records from different excel and combining records based on a column criteria
- 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 everyone,
I am new to Alteryx and using it to automate a routine task. Here is my question:
1. I need to combine data from file A with data of file B using a common column "Product Name". The issue is "Product Name" column in file A is not an exact match to "Product Name" in file B. Also, i only want data for those "Product Name" which are in File A.
2. In file A, Column A represents "Product Name" and column B is for "Owner". For each product we have different owners, and i want this data to be represented as one row for each product i.e. concatenate the owner name.
Please see below the sample files attached for reference.
Thanks
Arun
Solved! Go to Solution.
- Labels:
- Best Practices
- 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
Hi
I am unable to open the file attached (as i might be using an older version); i am able to work on the file as suggested except for the summarize part. Can you attach a snip of field selection.