Adding missing dates between the data and replicating the data for the recent date

Question

Hi Everyone,

I have a complex ask. I have provided the expected input and the output file.

In the input file, I have Customer, date and other fields with respect to customer.

If you see the input file, for example,we have data for 1st Jan and 6th Jan 2022.

What I need is to populate the missing dates between 1st Jan and 6th Jan and  copy the data  of the last transaction date (in this case, 1st Jan) to all the filled missing dates. Which means all the customer who had their data on 1st Jan will also have on 2nd jan,3rd jan, 4th Jan and 5th jan.

One thing to note is that the difference between two dates can range between 1 to 7.

Irrespective of other fields, i just want all the data to be copied for the missing dates.

Required on an urgent basis.

Thanks

Output.xlsx

Input.xlsx

Clifford_Coon · Answer

@nagakavyasri , Thanks for stepping in on the clarification.  @Maanu I'm glad this helped. (I didn't see your until after @nagakavyasri responded).  As a hint, when you @ reference someone, they will get a notification.

Hapy solving ;-)

nagakavyasri · Answer

@Maanu

select 'Allow all appends' in Append tool to remove the error.

Maanu · Answer

Thanks a lot for the solution.

It worked well for the dummy data that I provided but when i try to run it on the original data, I get an error in the Append component.

The error is There were more than 16 records in the source.

In original data, after summarizing, i have 243 dates and 25K customers.