Forum Discussion

newpbiuser01's avatar
newpbiuser01
Helper V
2 years ago
Solved

Combining Tables with No Matching Column

Hello,   I have two data tables coming from seperate sources, and I need to combine them both. The rows in the subcategory table are a subset of the category table and I'm trying to combine them so...
  • rsbin's avatar
    2 years ago

    newpbiuser01 ,

    Use the CROSSJOIN function:

    NewTable = CROSSJOIN( Category, SubCategory )

     

    Regards,