Forum Discussion
Adding column with a fixed value
Hi,
I have 2 tables:
US table:
| Product | Revenue |
| 1 | 1000 |
| 2 | 2000 |
| 3 | 1000 |
Canada Table:
| Product | Revenue | Country |
| 1 | 1000 | Canada |
| 2 | 2000 | Canada |
| 3 | 1000 | Canada |
I have to merge these 2 tables and I want to add Country column in US table. I tried using add column, but couldn't work. How can I add another column and its values in the US table?
Expected outcome:
| Product | Revenue | Country |
| 1 | 1000 | Canada |
| 2 | 2000 | Canada |
| 3 | 1000 | Canada |
| 1 | 1000 | USA |
| 2 | 2000 | USA |
| 3 | 1000 | USA |
Thanks for the help!
Hi
You can do this in Power Query Editor.
Add custom column with formula ="USA"
6 Replies
Hi
You can do this in Power Query Editor.
Add custom column with formula ="USA"
Anonymous
Just to illustrate how to do this in Power Query:
1) go to Power Query ("Transform Data" in the ribbon
2) select your US Table and choose "Add Custom" from the Add column in the ribbon:
3) Name the new Column "Country" and add the code as shown:
4) Select "Append Queries" from the ribon and choose "Append as new":
5) in the dialogue, select the "Canada" table to append to the US table:
6) and your done - "Close and apply":
Go to Data View. Add new column
Country = "USA"
In Canada
Country = "Canada"
