Forum Discussion
Possible to create a new column within Query Editor?
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?
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.
1 Reply
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.