5 Replies Latest reply: Jul 14, 2016 5:05 AM by Robert Mika RSS

    Merging tables

    Walter Coleman

      Trying to join these two tables.

       

      Customer_FX:

      NOCONCATENATE

      LOAD

           FX_Key,

        Source,

           Market,

           Account,

           Customer,

           Segment,

           Currency,

           Month,

        Year,

           MonthYear,

           Month_Year_Currency,

           Actual,

           MonthID#,

           MonthYear#

      RESIDENT Customer;

       

      MergeAll_FX:                    

      NoConcatenate

      Load

         FX_Key,

         ThisFXRate,

         ThisFXMonthID#,

         ThisFXYear,

         ThisFXCurrency,

         ThisFXMTHYEAR#

      Resident Currency_FX;

       

      Now I'm trying to add table 2 field to the main Fact table Customer_FX:

       

       

      left join (Customer_FX)

      Load

        ThisFXRate

      Resident MergeAll_FX

      group by FX_Key;

       

       

      Getting this error message:

       

      Aggregation expressions required by GROUP BY clause

      The error occurred here:

      left join (Customer_FX) Load ThisFXRate Resident MergeAll_FX group by FX_Key