Forum Discussion

yuvanne_11's avatar
yuvanne_11
Frequent Visitor
4 years ago
Solved

Appending Queries

truptis amitchandak 

Hi,

I am having a problem with appending queries. 

As in the below image I am having 5 tables that I imported from excel. I want to combine all the 5 tables and have them as one table. The attributes inside each table are year, month, country of the store, and so on

I tried to append them as a new table called 'OSA' but all the data is not getting displayed properly. For example: After I append the query I am not able to see data for May, June, July, August, Sept 2021. And for some reason, I am having a two-month table repeated. Like I expected to have just one month table where all months get combined but instead, I have two.

I really don't know where the mistake is, tried doing it a couple of time but the initial few months does not appear 

Need Help
  • Hariharan_R's avatar
    Hariharan_R
    4 years ago

    Hi yuvanne_11 

    Append query is straight forward in Power BI.

     

    1. Add one custom column on all your table like "May 2021" or may be a file name like below

     

    2. Append as new query. if the names of the columns are same across all the files then it will be appended in same column.

     

    Thanks

    Hari

    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.

    My Blog :: YouTube Channel :: My Linkedin


2 Replies

  • Hariharan_R's avatar
    Hariharan_R
    Solution Sage
    4 years ago

    Hi yuvanne_11 

    Append query is straight forward in Power BI.

     

    1. Add one custom column on all your table like "May 2021" or may be a file name like below

     

    2. Append as new query. if the names of the columns are same across all the files then it will be appended in same column.

     

    Thanks

    Hari

    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.

    My Blog :: YouTube Channel :: My Linkedin


  • yuvanne_11's avatar
    yuvanne_11
    Frequent Visitor
    4 years ago

    Hi Hariharan_R 

    Thank you for your reply.  Since the names of the column were different the append appeared differently. But there is this one column the 'month' which is not merging together, rest columns are aligning. 

    Like for example I have a sheet which includes June, July and August 2021 data its just that this sheet is not appending with other. Rest of the sheets are working good. But its just this sheet the month column is not appending. When I append all the sheets I am able to see two month columns instead of one. I really dont know whats the reason.