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.
|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||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||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||Combine two In-DB data streams based on common fields by performing an inner or outer join.|
|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||The Make Group tool takes data relationships and assembles the data into groups based on those relationships.|
|Fuzzy Match||Identify non-identical duplicates in a data stream.|
|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||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||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||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.|