Forum Discussion

vipett's avatar
vipett
Icon for Helper III rankHelper III
4 years ago
Solved

Combine two columns and multiply occurrences

I have a column called date in one table : 2021-01-01 2021-01-02 2021-01-03 2021-01-04 etc   And another column called Items in another table Item A Item B Item C Item D etc   I would l...
  • SpartaBI's avatar
    4 years ago

    vipett 
    TABLE = CROSSJOIN(Table1, Table2)

    In case it answered your question please mark this as a solution for community visibility. Appreciate Your Kudos 🙂