In Database row creation

[Rohitpm]

HI Guys

I am trying to prepare some data so that i can use it in a coxcomb diagram in tableau and as such I need to have a row for each category for each date. As a result i am trying to do this by taking our calendar db and then add a row for each of the products within it.

So i am starting with:

Date

01/01/2017

02/01/2017

03/01/2017

04/01/2017

05/01/2017

06/01/2017

07/01/2017

Product

Books

Cloaks

Helicopter

and want to end up with:

Date	Product
01/01/2017	Books
01/01/2017	Cloaks
01/01/2017	Helicopter
02/01/2017	Books
02/01/2017	Cloaks
02/01/2017	Helicopter
03/01/2017	Books
03/01/2017	Cloaks
03/01/2017	Helicopter
04/01/2017	Books
04/01/2017	Cloaks
04/01/2017	Helicopter
05/01/2017	Books
05/01/2017	Cloaks
05/01/2017	Helicopter
06/01/2017	Books
06/01/2017	Cloaks
06/01/2017	Helicopter
07/01/2017	Books
07/01/2017	Cloaks
07/01/2017	Helicopter

Would this be possible?

Thanks

Ro

[paul_houghton · Accepted solution]

Hi Ro,

in this case, I would suggest that you create a cross join situation for the indb to work. The way I did it was create a "1" column for both of the input tables then joined on that field. because every row is the same in the 1 column every row from the date data set gets joined to every row from the product data set

[Rohitpm]

Awesome thanks alot!