Forum Discussion
jnrezk
Helper III
Helper IIIformatting & merging 3 tables in matrix view
Hi - I have 3 tables. Two are from SQL server so I don't think I can really alter it much. The other is an excel file. I need to connect the 3. Table 1: SQL server looks like this: Week End Pl...
Hi jnrezk ,
Did you try joining it in Power Query?
If there are 3 tables:
1) sql plans
2) sql quotes
3) excel - targets for plans and quotes
They all have week information. Use this week field to merge tables (as new query if needed) and you will have all fields in one table.
Start from table which will always have data.
Example: select Excel table, merge queries as new, merge with Plans table.
Then inside that new table, go again to merge queries as new, merget with Quotes table.
Expand needed columns (value, no need for week).Best regards,
Nemanja Andic
nandic
Resident Rockstar
Resident RockstarHi jnrezk , you accepted my answer as solution.
As v-kelly-msft provided in-depth details which meet your need, you should accept that answer as solution.
Cheers,
Nemanja Andic