Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

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's avatar
    v-juanli-msft
    Icon for Community Support rankCommunity Support

    Hi Anonymous

    Modeling->New Table

    enter the formula

    Table = CROSSJOIN(Table1,Table2)

     

     

    Best Regards

    Maggie