Forum Discussion
Column data = table name
I would like to append two tables, but I would like to be able to differenciate which data came from which table. Is there an easy way to pull the table name into the a column named "table" and use t...
Add table name with your value using "Add Prefix" In Query Editor Window . Then you do the merging.
Eg. Vale = 103, Then Add "Table1" , O/P = Table1103
From the DAX
Create new Column
Value = MID(O/P,7,5) -- 5 give how long max digit u have
Then u change the column datatype as Integer .
It will work.
I tried that, but when I append the two tables it will only take the new column from the original table and will not add the new data from the other table for that column.
Add a custom column to each query before the Append with something like "=1" and "=2". The column name would be the same but when you import them, you know which row came from which original table.