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 have a table that matches products sold together (product 1 together with the various product 2 results). In the excel file, product 1 information is that which was originally the row names in a matrix and product 2 was the original column names in a matrix. I transposed the columns so that the row products will show the matches in a table format. (However, after I prepared data to join it with this specific data, the joins literally only swops column names around and what was the "Row_" fields is named the "Col_" fields and what is supposed to be the '"Col_" fields is named the "Row_" fields as you can see in the attached Excel example. (The top sample is after the first join and this data is correct, but the second join changes the names as displayed in the bottom sample.) Does anyone know why the join tool does this?
I will have to create similar data and use the workflow. Will post it. The original data is confidential. I did check for the integrity of the data and all looks fine to me. I find the 'behavior' of the join tool to be very unusual. I did wonder if the Alteryx tools can have 'bugs' in them.
Any software can have bugs, but a bug in the Join tool would be VERY surprising.
Can you post a screenshot of the Join tool configuration window ? There must be something in there. I can see what you mean in the attachment, but really need to see the configuration to explain it further.
@Roche I was wondering what could be the cause of the "switching" data between columns and I thought maybe you have set up the tool to configure columns by position (instead of "by column name"). In that case if the order of columns in both data sets is different the outcome could be as you described. Please let me know if this is the case.
Hi @Jarek and @cmcclellan. I have managed to come right. After going back to the flow I added sort tools and then it seemed to be fine. However I am sure that the column and row fields were swapped, since it was clear from the screenshots that I took, which I will not be able to share with you. The data is sorted out, but I still have the question as to why the data (/ tool) behaved like that. Thank you for helping.