fill date with data until next date and data appears in SQL using databricks

Viewed 28

I have information with the date and card info

dt card_name
2022-09-12 card1
2022-09-12 card2
2022-09-13 card3

I am expecting an output like this

dt card_name
2022-09-12 card1
2022-09-12 card2
2022-09-13 card3
2022-09-14 card3
2022-09-15 card3
2022-09-16 card3
2022-09-17 card3
2022-09-18 card3
2022-09-19 card3

unitl the next date appears, I want the data to be filled automatically

0 Answers
Related