Hello,
I hope someone can help me with what might be a simple solution but despite experimenting with various tools and searching the forums, I haven't been able to find the solution yet.
I'm basically trying to split one row into multiple rows based on a set % split. I'm trying to slice and dice a dataset into new industry classifications. Doing this manually in Excel would take me a long time, especially as different percentages apply to different countries. Wonder if there is a tool in Alteryx which can make this process easier?
I've attached a sample Excel file with what I'm trying to do, hopefully it's clear.
Thanks!
Solved! Go to Solution.
Hi @golfromeo
Here's one approach. I used a 'mapping' table to specify industries that have a sub-industry and appropriate %s. Then this data is joined up and transposed to update the amounts, and cross-tabbed back to the original format. Let me know if this works for you, I think this can be easily updated to layer in the country aspect.
That works nicely, thank you!!