Create table with dates and categories

Question

Hi!I have a single column table containing dates as below:Each day is on a separate line - no duplicates.&nbsp;Now I would like to add a new column with categories. I would like to create rows so that each contains a date + category combination. The end result would look like this:datecategorie01.01.2019Categorie A01.01.2019Categorie B02.01.2019Categorie A02.01.2019Categorie B03.01.2019Categorie A03.01.2019Categorie B&nbsp;And so on...Do you have an idea how to automate this process so that I don't have to manually enter each combination one by one?

hotchilli · Accepted Answer

You start with 2 tables (dates and categories).&nbsp; In the dates table, add a custom column.
In the dialog that pops up just write CategoryTable[the Column]&nbsp; &lt;-- Your names here
Then Expand the Column 'To Rows'

Forum Discussion

Create table with dates and categories

2 Replies

Related content

Create new table

Lakehouse Table Generate Create Table

Create KPI table with matrix table, with category and sub-category

Create rows from 2 tables

Creating Date Tables

date	categorie
01.01.2019	Categorie A
01.01.2019	Categorie B
02.01.2019	Categorie A
02.01.2019	Categorie B
03.01.2019	Categorie A
03.01.2019	Categorie B