Append 4 tables queries

[TomerIwanir1]

Hi

I have 4 tabels (BL, BL -1, sales, org)

Each table contain only one column named "Order number"

I want to create a new table in the PQ which contain one column that merging each column from the tabels,

I tried using append queries but I got the pic below which seems that he created 4 columns table and I want one column that merging the tabels, any ideas what to do?>

thx

[TomerIwanir1]

Sorry I meant "order line"

I want to take the 4 tabels and combain them into 1 table with 1 column.

[v-aatheeque · Accepted solution]

Hi @TomerIwanir1 ,
Thanks for reaching out to the Microsoft Fabric Community forum.
@lbendlin Thanks for prompt response.
I have created a sample dataset as follows, based on your description :
Sheet 1:

Sheet 2: 

Sheet 3 :

Sheet 4 :

NOTE : Replace Table1, Table2, etc., with the actual table names, and ColumnName with the relevant column names

The desired output after appending the tables is shown below:

Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.

[TomerIwanir1]

Yes, thx all! I didnt know column names should be the same

thanks again !

[lbendlin]

you will have to rename them before the append.

[lbendlin]

You don't seem to have a column "Order number".

I want to create a new table in the PQ which contain one column that merging each column from the tabels

Please elaborate what you mean by that.