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.
Hi, so I have joined two excel files together using asset number as the key to join by specific fields. The problem is that the files use the same asset number for the hardware asset amount and personal property tax. When I use the join tool, because they have the same asset number, alteryx only displays the asset number once. Is there a way, using the join tool, to display the same asset number in more than one row?
It would be helpful to see the flow with some sample data. If you have the join in place it would seem that you expected the same value in both sources...thus why keep them separate in 2 or more rows? should you be using a UNION tool?
That said have you considered adding another key field to join on like Asset Type? how do you know it is Hardware vs Pers Prop Tax, there must be some field that allows you to differentiate this right? Thus join on Asset# and on Asset Type.
Again you will need to share your problem more fully, typically by sharing the flow or a cleansed version. The best solutions come with a clear understanding of data and the objective.