Forum Discussion

RMV's avatar
RMV
Helper V
9 years ago
Solved

Combine 2 dataset

Hi,
If i have a dataset consists of 1 column with value date from 1 jan 2017 until 31 dec 2017.
The other dataset consists of 1 column with value all states in US.
Is there a simple way to combine these 2 dataset that will generate 2 columns of combination of date & state?

Really appreciate the help

Regards,
  • RMV

     

    Go to Modeling New Table:

     

    MyNewTable = CROSSJOIN(TableDates,TableStates)

2 Replies

  • Vvelarde's avatar
    Vvelarde
    Community Champion

    RMV

     

    Go to Modeling New Table:

     

    MyNewTable = CROSSJOIN(TableDates,TableStates)