Forum Discussion
Combine data column from different table
First add the new column in each table. You should the have 3 tables with 3 columns. All columns have the same column headings
then append the tables into 1 long table.
When end you have 1 table, then unpivot the country and subject columns. When you do this, you will be asked which column to aggregate, and how. Select sum of the numeric column
Hi Matt
I managed to add custom column as you advised but unfortunately after I try to pivot the first 2 column I didnt get the result that I want.,
What do you mean by "pivot the first 2 columns, with sum on the numeric column"
Do I need to pivot country name column and subject column for all three tables?
And how to do - sum on the numeric column as you advised earlier?
First add the new column in each table. You should the have 3 tables with 3 columns. All columns have the same column headings
then append the tables into 1 long table.
When end you have 1 table, then unpivot the country and subject columns. When you do this, you will be asked which column to aggregate, and how. Select sum of the numeric column