Custom column name of tables

[Asamadi]

I have 5 tables in Edit query

i want to append these 5 Tables and create a custom column that is the table names

how can i do that by M Query?

[Anonymous]

HI @Asamadi,

I'd like to suggest you define a custom table with table names and these tables which you mentioned.
then expand table column to achieve your requirement.

Sample:

let
    Source = #table(type table[#"Source"=text, #"Detail"=table], {{"Table1",#"Patient Link"},{"Table2",#"Patient"},{"Table3",#"Patient Review date"},{"Table4",#"Smoking"},{"Table5",#"Smoking status"}})
in
    Source

Expand:

Reference link:

Creating Tables In Power BI/Power Query M Code Using #table()

Regards,

Xiaoxin Sheng

[Asamadi]

Thanks that works but unfortunately it needed to type the tables name

[nerd2000]

that is not a solution in my opinion and i am lookign to do the same thing

[Hardik]

https://support.office.com/en-us/article/insert-a-custom-column-into-a-table-power-query-2dbb579a-91...

Trya nd implement from the link shared.Hope this helps 🙂