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

Question

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 · Answer

@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.

0609-nakennedy.yxzp

nakennedy · Answer

here is a Mock data set

MOCK_DATA (2).csv

Qiu · Answer

@nakennedy 
Any sample data for us?