Possible to create a new column within Query Editor?

[Anonymous]

I have 2 tables and want to merge the two by appending the two datasets into a new table.  I understand you can do this with the Query Editor.  However, before appending, I want to create a new column in the new table, highlighting the row is from "table 1" or "table 2".

How can I achieve this?

[PattemManohar · Accepted solution]

@Anonymous  In that case, add your SourceTable field as custom column in both the tables ideally before appending them. But if you have already append them as a new table still you can add your custom fields as below and it will reflect in your appended table automatically.