Forum Discussion

OzgurKlc's avatar
OzgurKlc
Frequent Visitor
2 years ago
Solved

Join two table

Hi All,

 

I have two tabel

 

table1

Product CodeScarp codePart CodeYear_Month
0101ATYTEBC2023.01
0101AEYTGBC2023.01

 

table2

ProductCodePartCodeQtyScrapqty
0101AEYT53

 

relation table1.productcode = table2.productcode

 

I would like to get like below ,

YearMonthProductCodePartCodeTotal QtyTotal Scrap
2023.010101AEYT53

 

Can you assist?

Thx

Need Help
  • wini_R's avatar
    wini_R
    2 years ago

    Hi OzgurKlc,

    You can merged both tables in power query using 2 common fields between them: Product Code and Scarp/Part Code. Then just expand both quantity columns and apply any transformation steps if needed

     

1 Reply

  • wini_R's avatar
    wini_R
    Solution Supplier
    2 years ago

    Hi OzgurKlc,

    You can merged both tables in power query using 2 common fields between them: Product Code and Scarp/Part Code. Then just expand both quantity columns and apply any transformation steps if needed