Need help creating zero amount records in alteryx for months without customer transactions

[nakennedy]

Hi everyone,

I'm currently working with a revenue by customer dataset that includes three columns: customer name, date, and amount. I'm trying to create records with zero as the amount for months where we didn't have any business with a customer. My goal is to have a record for each customer for every month across the three-year dataset. I tried to use the generate rows tool, but it does not seem to be working.

Thank you!

[Qiu]

@nakennedy 
Any sample data for us?

[nakennedy]

here is a Mock data set

[Qiu]

@nakennedy 
I generate every Month based on your minimum Month and Maximu Month of your dataset

Then join back to the original datastream, the ones are not matching are the ones we are looking for, I think.