Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

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

nakennedy
5 - Atom

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!

3 REPLIES 3
Qiu
21 - Polaris
21 - Polaris

@nakennedy 
Any sample data for us?

nakennedy
5 - Atom

here is a Mock data set

Qiu
21 - Polaris
21 - Polaris

@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_A.PNG0609-nakennedy_B.PNG

Labels
Top Solution Authors