This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I think it would be nice to be able to more easily reorder fields that you're joining by in the Join tool.
For example, I have already joined by CASS_Address and CASS_City. After I did this, I realized I wanted to go back and join on Name, too, and I want that to be first. How the tool is configured now, if I want Name to be first, I must redo all of the drop downs. I would like to be able to add Name to the next set of open drop downs then use some arrow buttons to be able to move them up in the order (similar to the Summarize tool).
We build some pretty robust maps with multiple connections and it would be great to copy the map tool and paste it with all of the connections when we want to tweak the map slightly but keep our original map. It is a regular occurrence for us to have a very detailed map grouping by trade area name and then may want to have an overview map with all of the same connections but slightly different layout. Tracking down the connections, reconnecting them and naming them accordingly takes a substantial amount of time even in the most organized of workflows. This function would be a huge time-saver. It would also be of value with joins and unions - anywhere you have multiple streams coming in.
I would like to be able to use the join tool to join on inequalities. We could join two tables, A and B on A.value is >= B.value1 AND A.value <= B.value2. This would replicate the "between" function in SQL. The equvalent feature in Tableau is pictured below.
I have a process that joins 3 data sets to identify a specific group of data and apply certain ruling. From this created file, I need to extract the data (not the headings) from specific columns and insert into an already existing template. The template has formatting that needs to remain in order for it to function.
I've come to realize that the JOIN tool is case-sensitive by design but it would be helpful if you could turn that behavior on/off (via checkbox?) within the JOIN tool. For those of us that work predominantly in database environments that are not case-sensitive, this default behavior has caused me problems many times. Having to force the case to either upper or lower upstream of the JOIN on both flows in order to ensure a successful join is an extra step that would not be necessary if you could disable case-sensitive with a checkbox.
In other data programs like access or Toad you can put conditions on a join. You can choose if something is greater than, less than, left join, right join, etc. But with Alteryx you are only allowed to join a perfect match. It would be really great if you could add that functionality into 9.0
When bringing data together it is often needed to assign a source to the data. Generally this happens when you union data and need to know things later about the data for context. It would save time to generate a source field that is assigned based upon the input connections of the union tool. Perhaps when unioning data you can assign a name to each input stream?
I haven't been able to find a similar idea, but I have a scenario were I'm fully joining a dataset but I get a mismatch of column names.
When using the column renaming functionality in the Join tool, data sent through the Left or Right connector is not renamed. When I'm performing a Full Join the Union tool is adding these columns to the resulting table.
The renaming column functionality of the Join Tool should apply to all join types for consistency. My workaround has been to avoid renaming columns in the Join tool if aiming to perform a multi-join.
When manually configuring a Union tool within a module/app, once it's saved, if you go in at any point in the future, and change anything upstream from the Union Tool, it causes an error "[some field name] has been changed and the Union Tool needs to be reconfigured".
This happens even if you do not reconfigure any upstream tools, but mearely access them, physically move them, say, an inch to the left or something like that, etc. Basically if you just "touch" any tool upstream, the Union Tool thinks that the manual config needs to be done over. But even if you do reconfig the Union Tool (either delete it and bring a new one in, or change the current one to Auto and then back to manual), it STILL does not recognize the tool as being correct.
The only way I have found to correct this issue is to click Play, and let it throw the error. Add Select Tools before the Union Tool to change the names to be common, then click on the Union Tool, and switch it to auto. Then click Play again. This can be very inconvenient if you have a module that takes hours (although you can limit your input records).
My suggestion would be to either disable the manual configuration, or add notes to the Help Files stating to use the manual configuration at your own risk, because once it's set and works at the time of creation, you cannot modify any upstream tools thereafter or else it will break the Union Tool and it cannot be repaired -- only choice is to use the Select Tool as I described above
I can see that the Venn diagram is very nice for a new user to understand the Join tool (which is a super-great tool by the way). But I would like to be able to close up the Venn diagram to give more room to see the variables listed below.
Problem: When you configure fields manually in the union control and then go back to remove a field it throws up an error that "XYZ field missing" Solution: One needs to change the config to "arrange fields by name" then refresh before you can arrange fields manually
I would like this problem to be handled by some method that tracks for changes and warns the user rather than throw an error.
It would be great to have the option in the Join tool to "Delete duplicate fields from Left input" and same for "Right input". the field might have the same name, but the data in them might be different.
Please create a way to swap or change the order of the inputs and outputs for tools with two or more inputs and outputs.
For example: When creating a workflow a join tool can end up moving to a location on the canvas that causes flow paths to cross. To fix the overlapping paths with a simple option of change order of input and output with a simple up and down would be much better than deleting the paths and reconnecting and redefining all of the join fields.
When using ConsumerView macro from Join tool palette for demographic data matching from Experian, the matching yield is higher than compared to Business Match marco. It would be great if the matching key for telephone number could be added to Business Match (US) tool the yield might increase and will provide more value to the firmographic data sets than it currently yields by matching just the D&B Business Names and addresses only.
Today, any Alteryx tool with "Select" functionality has an option for "Dynamic or Unknown Fields" which, when checked, allows any new fields to pass through that tool. This is a great function for most of the tools as you can allow workflow updates to pass through the tool without issue.
However, in the Join tool, there are some use cases where there is NEVER a reason to pass new fields from one side or the other into the tool, but you might still want new fields from a primary process. Examples being something like a lookup/cross-reference to do an inclusive join, where adding new fields to the lookup might inadvertently pass these downstream. Having the option to only allow unknown fields from one side through would greatly enhance this output.
In communicating with your agent Eddie Wong about a question (ref:_00DE0JJZ4._50044uMC7T:ref), he confirmed that Alteryx currently does not have an option to coalesce IDs when merging tables in the "Join" or "Join Multiple" tools. This functionality is available in SQL and SAS, for example.
This code demonstrates it.
input ID age;
input ID height;
select coalesce(d1.id, d2.id) as id,
on d1.id = d2.id;
Could you please consider adding this option into the "Join" and "Join Multiple" tools?