Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Take data from one table to another

Hello! I have two tables. First have columns Name and Date. Second  - Name, Date, Money. In Power Query i need to make user functions which from second table add column Money in first table. It is...
Need Help
Nathaniel_C's avatar
Nathaniel_C
Icon for Community Champion rankCommunity Champion
5 years ago

Hi Anonymous ,

 

Go to the home tab in Power Query, and select Merge Queries


Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel

 

 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

I should do it without merges)

 

  • Nathaniel_C's avatar
    Nathaniel_C
    Icon for Community Champion rankCommunity Champion
    5 years ago

    Why is that?

     

  • v-jingzhang's avatar
    v-jingzhang
    Icon for Community Support rankCommunity Support
    5 years ago

    Hi Anonymous 

     

    Could you please let me know why you don't want to use merge? Is your data structure a little special so Merge Queries is not applicable to it?

     

    Per my understanding, merge queries is the simplest way to realize your requirement. With a merge query, you can achieve similar goals to the Excel VLOOKUP function.

     

    You can select First Table in the Queries and click Merge Queries to get new columns into First Table. In Merge window, you can select one or multiple columns to match rows. In the following image, I select Name and Date columns to match with. After merging, you can click the NewColumn expand icon and select which columns to add to First Table. You can also add aggregate values in this step.

     

    Reference:

    Merge queries (Power Query) - Excel (microsoft.com)

     

    Best Regards,
    Community Support Team _ Jing Zhang
    If this post helps, please consider Accept it as the solution to help other members find it.