Forum Discussion

Meg_Srikaran's avatar
Meg_Srikaran
Frequent Visitor
8 years ago

Append two tables from postgres with only distinct fundcodes

Hi I'm trying to append two tables where I'm trying to avoid duplicate fundcodes from table2 below is my sample code.

 

In my output table im only getting data from table2 and nothing from table1

 

let
    Source = PostgreSQL.Database("sddal021.superiq.com.au:5432", "superiq_adb"),
    public_report_funds_view = Source{[Schema="public",Item="report_funds_view"]}[Data],
  
    Source1 = PostgreSQL.Database("sddal101.superiq.com.au:5433", "superiq_adb"),
   public_report_funds_view_2= Source{[Schema="public",Item="report_funds_view"]}[Data],
Filter_List = List.Difference(public_report_funds_view[Fund Code],public_report_funds_view_2[Fund Code] ),
     Table2b = Table.SelectRows(public_report_funds_view, each List.Contains(Filter_List, [Fund Code] )),
     Final = Table.Combine( {public_report_funds_view, Table2b} )
in
     Final

 

Can someone please review my code and help with where I'm going wrong ,as this is the first time im trying to use M language.

Need Help
Show and Tell

3 Replies

    • Meg_Srikaran's avatar
      Meg_Srikaran
      Frequent Visitor
      8 years ago

      Thanks for replying the output table doesnot give me the correct number of funds which is around 30000 rows,it only gives me the 2111 rows which is the table 2 contents.