Matching records from different excel and combining records based on a column criteria

[Aryan1182114]

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

[seinchyiwoo · Accepted solution]

Hi,

Find and Replace tool can help you in mapping both columns of Product Name that might not be an exact match.

Also, you have the option of concatenating a column using the Summarize tool.

I have attached the workflow for your reference.

Cheers,

Seinchyi

[Aryan1182114]

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.