Forum Discussion
Anonymous
8 years agoNot applicable
table matrix - combine ?
Hi,
In the first table we have all dates in a year
In the second table we have a unique list of employees
Now we need a table that shows for each day and employee a record
With kind regards
2018-01-01
2018-01-02
etc
Thomas
Eric
etc
The result must be:
2018-01-01 Thomas
2018-01-02 Thomas
2018-01-01 Eric
2018-01-02 Eric
Hi Anonymous
Modeling->New Table
enter the formula
Table = CROSSJOIN(Table1,Table2)
Best Regards
Maggie
1 Reply
- v-juanli-msft
Community Support
Hi Anonymous
Modeling->New Table
enter the formula
Table = CROSSJOIN(Table1,Table2)
Best Regards
Maggie