Challenge #273: Filling In The Blanks

[AYXAcademy]

A solution to last week's challenge can be found here. 

This week's challenge was submitted by @Maskell_Rascal & @mceleavey - Thanks for your submission!

For this week's challenge, we have provided a list of transactions including the [Client_Number], [Date], & [Finance Amount]. Since not every customer makes a purchase everyday, they only appear on dates that they have made a purchase. We would like to include current customers in the dataset with a "finance amount" of 0 for the missing dates after their first purchase. They should not have entries for dates prior to their first purchase. Assume first purchase dates are the earliest entry in the dataset.

[Aaron_Harter]

Great practice with the Generate Rows tool!

Spoiler

[dsmdavid]

Spoiler

[DeanWest]

Glad I didn't miss the challenge today! 

Spoiler

[Blake]

Spoiler

Nice challenge @Maskell_Rascal and @mceleavey!

[JasonHu]

Spoiler

Here is my submission.

[Kenda]

Spoiler

[jferrone]

Thank you for providing this week's challenge

Spoiler

I find myself using Generate Rows tool quite a bit in the past few weeks. I don't typically use Imputation but this seemed like a good opportunity. 

[Toons]

My solution :

Spoiler

[alexnajm]

Good challenge to start the week!

Spoiler