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.
What logic are you currently using to determine your Matching Level values, and thus the order of your data rows in the result? I can't see an obvious method to get from your first table to the second from your initial explanation. If I can understand your current process, I expect that I would be able to reproduce this in Alteryx.
Hi @Niranjan123 I managed to produced the output you described using an Iterative macro. I've attached my workflow with the macro as well. Let me know what you think or if I need to explain in more detail the solution I produced.