Forum Discussion
Append 4 tables queries
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
Hi Anonymous ,
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 : ReplaceTable1,Table2, etc., with the actual table names, andColumnNamewith 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.
5 Replies
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 tabelsPlease elaborate what you mean by that.
you will have to rename them before the append.
Hi Anonymous ,
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 : ReplaceTable1,Table2, etc., with the actual table names, andColumnNamewith 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.
