I want to join dates with sales

[MKanchwa]

I have two tables - Sales and Dates Tables. I want the first date to come in front of the first 7 rows in sales data. Similarly the second date in front of the next 7 rows in Sales data. 

[FinnCharlton · Accepted solution]

Hi @MKanchwa , you can do it like this:

We use the generate rows tool to make 7 rows for each date. We can then join on record position to add the dates to the sales table. Hope this helps!

[MKanchwa]

Thank you very much @FinnCharlton