3 Replies Latest reply: May 16, 2016 9:11 AM by fredrik olsson RSS

    Table link and intervalmatch

    fredrik olsson

      Hi,

       

      I have SQL tables with Order and Invoice data but now I wanna link external data to the order data.

      I think I need to use intervalmatch but I need to make sure that CustomerType and SegmentId column matching also.

      I wanna add the external markups as Invoicelines to each order.

       

      Any help are appreciated!

       

       

      OrderIDOrderDateCustomerTypeSegmentID
      12342016-05-13Organic4

       

      InvoiceLineIDNameCodePriceCostOrderID
      132234Samsung TVJSDKDY10008001234
      23221Panasonic DVDPKKDLJ3002751234

       

      External markups:

      FromDateToDateCustomerTypeSegmentIDNameCodePriceCost
      2016-01-012016-12-31Organic4KickbackKSSYBJ250
      2016-01-01
      2016-12-31
      Referal2KickbackUIREKK100