Adding column with a fixed value

[Anonymous]

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!

[PaulDBrown]

@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":

[Anonymous]

Thanks, everyone for your input. I tried adding a custom column but I was just using single quotes, I should have used double-quotes. 

[Anonymous]

You should be able to add a custom column in the Query Editor with the code:

= "USA"

[amitchandak]

Go to Data View. Add new column

Country = "USA"

In Canada

Country = "Canada"

[Anonymous]

Add a calculated column to US Table.

Country = "US"

[Pascal_KTeam · Accepted solution]

Hi

You can do this in Power Query Editor. 

Add custom column with formula ="USA"