Forum Discussion
Combine 2 tables - PQ
Hi,
I need help with with some work I need to solve. I have a main Table with data that I get this updated using "get data from workbook" cause i use a Macro to put many reports from a folder to a Excel tab. So with this Main table I need to add or concatenate this with a Table that have range of period. The problem is that I don't know how.
| Main table | ||||||||
| Stage | Client id | CSG | Work | Start Date | Type | Projection | SG | Amount |
| Data | Data | Data | Data | Date | Data | Data | Data | Amount |
| Data | Data | Data | Data | Date | Data | Data | Data | Amount |
| Data | Data | Data | Data | Date | Data | Data | Data | Amount |
| Table option 1 | ||||
| Jan-20 | Feb-20 | Mar-20 | Apr-20 | May-20 |
| Calculation | Calculation | Calculation | Calculation | Calculation |
| Calculation | Calculation | Calculation | Calculation | Calculation |
| Calculation | Calculation | Calculation | Calculation | Calculation |
| Calculation | Calculation | Calculation | Calculation | Calculation |
| Calculation | Calculation | Calculation | Calculation | Calculation |
| Table option 2 | ||
| Jan-20 | Feb-20 | Mar-20 |
| September-15 | Q1 | FY16 |
| October-15 | Q1 | FY16 |
| November-15 | Q1 | FY16 |
| December-15 | Q2 | FY16 |
My result table should be:
| Result TABLE | ||||||||||||
| Stage | Client id | CSG | Work | Start Date | Type | Projection | SG | Amount | Jan-20 | Feb-20 | Mar-20 | Apr-20 |
| Data | Data | Data | Data | Date | Data | Data | Data | Amount | Calculation | Calculation | Calculation | Calculation |
| Data | Data | Data | Data | Date | Data | Data | Data | Amount | Calculation | Calculation | Calculation | Calculation |
| Data | Data | Data | Data | Date | Data | Data | Data | Amount | Calculation | Calculation | Calculation | Calculation |
| Data | Data | Data | Data | Date | Data | Data | Data | Amount | Calculation | Calculation | Calculation | Calculation |
| Data | Data | Data | Data | Date | Data | Data | Data | Amount | Calculation | Calculation | Calculation | Calculation |
| Data | Data | Data | Data | Date | Data | Data | Data | Amount | Calculation | Calculation | Calculation | Calculation |
| Data | Data | Data | Data | Date | Data | Data | Data | Amount | Calculation | Calculation | Calculation | Calculation |
How can I join the information to get this result table ?
Thanks !
Hi cristianml
You can use Merge Queries as per below.
https://www.youtube.com/watch?v=dTdFt9AvDHABest Regards,
Mariusz
If this post helps, then please consider Accepting it as the solution.
Please feel free to connect with me.
LinkedInHard to follow. Actual sample/example data is better generally. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490.
In your second table, generally, having columns like that by month/date is difficult. Better to unpivot those columns.
Hi cristianml ,
I think this is hard to achieve this goal, I didn't view any relationship between fisrt two tables , so I think it is hard to merge it or append it. In addition, I also don't know what is your expected output. So if possible could you please inform me more detailed information(such as your expected output and your sample data)? Then I will help you more correctly.
Please do mask sensitive data before uploading.
Thanks for your understanding and support.
Best Regards,
Zoe ZhiIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
Hi cristianml
You can use Merge Queries as per below.
https://www.youtube.com/watch?v=dTdFt9AvDHABest Regards,
Mariusz
If this post helps, then please consider Accepting it as the solution.
Please feel free to connect with me.
LinkedInHard to follow. Actual sample/example data is better generally. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490.
In your second table, generally, having columns like that by month/date is difficult. Better to unpivot those columns.
Hi cristianml ,
I think this is hard to achieve this goal, I didn't view any relationship between fisrt two tables , so I think it is hard to merge it or append it. In addition, I also don't know what is your expected output. So if possible could you please inform me more detailed information(such as your expected output and your sample data)? Then I will help you more correctly.
Please do mask sensitive data before uploading.
Thanks for your understanding and support.
Best Regards,
Zoe ZhiIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.