Forum Discussion
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.
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.
How could I make the formula?
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])
but how do I take columns from two separate tables?
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.