Alteryx Analytics

Join Tools

Today's analysts are faced with the reality that not all data is in one system or location. Getting access to that data is one step in the analytics process, blending and combining that data to make a more informed decision is a key component to create a working analytical dataset that analysts can make decisions on. Alteryx Analytics give analysts the ability to blend multiple data sources regardless of the data structure and formats through a number of tools.

This is a sample of the tools available in the Alteryx Designer. For the full list of tools, click here.

Icon Tool Description
Append Field Append Field Append the fields from a source input to every record of a target input. Each record of the target input will be duplicated for every record in the source input.
Find Replace Find Replace Search for data in one field from one data stream and replace it with a specified field from a different stream. Similar to an Excel VLOOKUP.
Join Join Combine two data streams based on common fields (or record position). In the joined output, each row will contain the data from both inputs.
Join In-DB Join In-DB Combine two In-DB data streams based on common fields by performing an inner or outer join.
Join Multiple Join Multiple Combine two or more inputs based on common fields (or record position). In the joined output, each row will contain the data from both inputs.
Make Group Make Group The Make Group tool takes data relationships and assembles the data into groups based on those relationships.
Fuzzy Match Fuzzy Match Identify non-identical duplicates in a data stream.
Dun & Bradstreet Business File Matching Dun & Bradstreet Business File Matching Match your customer or prospect file to the Dun & Bradstreet business file. (requires, Alteryx with Data Package and installation of the Dun & Bradstreet business location file)
Experian Household Matching Experian Household Matching Match your customer file to the Experian Consumer View Household file. (requires, Alteryx with Data Package and installation of the Experian ConsumerView Household and individual file)
Union Union Combine two or more data streams with similar structures based on field names or positions. In the output, each column will contain the data from each input.
Union In-DB Union In-DB Combine two or more In-DB data streams with similar structures based on field names or positions. In the output, each column will contain the data from each input.

^Top

Try Alteryx Designer for Free Download Now