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 question regarding a Join, but if there is a more elegant solution (which I suspect there is...), I am all ears.
What I want to know is which year contains a deadstock shoe. So what I started to do was Join on Table 1 Shoe1 and Table 2 Shoe, but I would have to repeat this 5 times to really know which year has a deadstock shoe.
Is there a way to Join through all of the columns? Not sure if Join Mulitple is the correct approach.
I've saved the workflow in an older version (10.6) - you should be able to open it now.
In regards to the Transpose, anything you need on the same line, you should keep as a 'key' field. All of the shoe fields will be your 'data' fields. If you decide to cross tab the data back into it's original format, then 'Group By' all of the fields you used as 'key' fields in the Transpose.