Forum Discussion

jracer007's avatar
jracer007
Helper IV
8 years ago
Solved

Add Column to other table

Hello community,

How can I add these two columns (Page and Total Events)to another table?

Note: the data source is from Google Analytics.

Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    8 years ago

    This is the part of your message that is not clear. You mention Pages and Total Events which seem like they are part of the same table. You can use UNION to mash tables together or NATURALINNERJOIN. But, I still doin't have a good understanding of the output that you want exactly.

7 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    8 years ago

    Depends. You could just reimport the information you want (copy your query(ies)).

     

    Or, you could use something like SUMMARIZE or ADDCOLUMNS to create a new table in your data model.

     

    Not entirely sure what you are asking. Are these two separate tables and if so, how are they related?

    • jracer007's avatar
      jracer007
      Helper IV
      8 years ago

      they are not related, and those are the tables are separate.

      • Greg_Deckler's avatar
        Greg_Deckler
        Community Champion
        8 years ago

        So, you could just go to the Modeling tab you can choose New Table. Then you can put in a formula like:

         

        Table = SUMMARIZE(Table,[Page],"Events",[Total Events])