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 often find myself combining data from different sources. It is external data I have no control of. One of the main problems I face is that columns are often named differently: 'this is a comment' in table1 is called 'a comment this is' in table 2 and 'comment' in table3.
The union tool is convenient for tables with few columns only: when the columns are many, moving them left and right is confusing and time-consuming.
I currently list and associate the column names in Excel, then use this as the basis to rename columns in Alteryx with a select tool, then do a union in Alteryx.
It would be extremely convenient and efficient if Alteryx had some kind of drop-down box to do this association. I have tehse steps in mind:
1) Alteryx tries to guess associations by column names (if two columns have the same name in two tables, they are associated to each other)
2) for the ones with no associations, rather than scrolling left and right as is now the case with the union tool, the suer would be able to choose from a drop-down list. This would make it evident that 'this is a comment' matches 'a comment this is', etc