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
Solved! Go to 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
Awesome thanks alot!