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 All,
I'm new to Alteryx and trying to figure out how to solve the below problem.
I have a sales dataset with Country and Segment dimensions. But some countries do not have data for all the Segments.
So I need to generate missing segment rows for each country with 0 sales.
Usually, I would use Excel pivot table feature "Show items with missing data". But I have a huge dataset that Excel is not able to handle.
As shown in the below screenshot, I need to transform the "Before" table to "After" table. Thanks in advance for any help.
Solved! Go to Solution.
I found the solution the same way actually!
Thanks
Nice! Can't argue with 2 people agreeing!
Genius! This solved my problem. Thank you so much!