Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

append two columns from two tables with difference sizes

Hi all,

 

We are in the process of calculating Management Fees for each Loan & Product Type (PL, Car,etc...).

 

I have Table 1 contains 20 columns from Jan to Aug till date for this year.

Table 2 contains 9 columns for Sep month. Here unique column name is "Loan Number"

 

I have to copy new generated "Loan Number" rows pertains to Sep from Table 2 into Table 1 to make that Jan to Sep till date.

 

Regards,

AM

1 Reply

  • JosefPrakljacic's avatar
    JosefPrakljacic
    Solution Sage
    6 years ago

    Hey Anonymous

     

    you need to MERGE the queries in Power Query.

     

    Here is a youtube video that tells you how to do it.

     

    Please don't forget to give a 👍 and accept the post as solution. (If it helped 😅)
    Have a nice day!

    BR,
    Josef
    Graz - Austria👍