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 use both Tableau and Alteryx and have had to approach this problem many times; the solution is sometimes known as 'padding' or 'scaffolding' your data, and it's really simple with Alteryx.
All you have to do is use the summerize tool to create the list of values that you need with each of the fields (i.e. one to summerize each client and products, and a 2nd to summerize each date).
You can then append these streams together to create a list of all possible combinations, and then join this list against your dataset. This will highlight any instances of missing data which you wish to 'pad' or 'scaffold' to which you can do a left outer join to bring this through.
For this example I have used different data to that you have sent, purely because it would be much better for your learning if you translate the logic I show you, into a workflow that works with your data (also you file is painfully slow to run, i'd advise you use the 'cache and run' feature so you don't have to sit through the loading process everytime you hit run!