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.
It's the most wonderful time of the year - Santalytics 2020 is here! This year, Santa's workshop needs the help of the Alteryx Community to help get back on track, so head over to the Group Hub for all the info to get started!
Rather than joining, wouldn’t it be better to standardize the columns and then use a union tool? If you have time series data Alteryx tends to like it better when it is in vertical format with a row for every month in your case. If you have months in different columns you may need to use a transpose tool in order to get it in the right format prior to union. If you can provide a sample data set it will be easier to mock up a workflow.
I second @BrandonB 's approach of using a union rather than a join for this purpose.
In addition you can use the Dynamic Rename function to rename the fields automatically, rather than manually renaming each column individually prior to the union. If the columns are always in the same order, you can use a single column with all of the field names in order from left to right. Alternatively, if the fields are not always in the same order, you can create a "mapping table" with the field names you'd like to use in one column, and the field names present in each of the input files in separate columns. See attached for an example using the first method.