Extra column that can filter table name from Appended multiple tables

[alipezu]

Hi All,
I have multiple tables Table A and Table B and I have appended those.
Now the problem is that Appended query doesn't have A column that shows me a table name??
So I would like to have a column (Table Name) that can show me a table name. so that I can filter it later.
Please help.
Thanks.

[TABLE="width: 500"]
<tbody>[TR]
[TD]Table Name[/TD]
[TD]Employee name[/TD]
[TD]Employee ID[/TD]
[/TR]
[TR]
[TD]Table A[/TD]
[TD]David[/TD]
[TD]10001[/TD]
[/TR]
[TR]
[TD]Table B[/TD]
[TD]Richard[/TD]
[TD]10022[/TD]
[/TR]
</tbody>[/TABLE]

 

[alipezu]

My all tables are in a same workbook..

 

[MarcelBeug]

Power Query has a function for exact this situation: Table.FromPartitions.

Code for your situation:

= Table.FromPartitions("Table Name",{{"TableA", TableA},{"TableB",TableB}}, type text)

The first parameter is the name of your additional column.
The second parameter is a list of lists, each inner list is a pair consisting of the table name and the table itself.
The third argument is optional for the type of your new column (default any, in the code above: type text).