3 Replies Latest reply on Mar 1, 2017 2:44 AM by Norbert Maijoor

    Date blending

    Béatrice LORIOT

      Hi Everyone,

      Is there a way to blend dates and get all dates available from both tables ?

      When I do blend dates, I get only the dates from the first table and data from the second table are added to the first one, but dates from the second table (not present in the first one) are not showing. I would like to do kind of an "outter join". I am enclosing a twbx with xls but original data come from an API, I can't do anything:  I can't pivot, I can't flatten data, I can't change them. I can't do a join.

      The expected result is this one and answers the question : How many customers and providers were touched (created or modified-calculated field is [date to be considered]) during 2017

       

      [Date to be considered]CustomersProviders
      01/01/201721
      05/01/20172
      08/01/20171
      09/01/20171
      10/01/201721
      11/01/20172
      12/01/201722
      15/01/20173
      16/01/20171
      17/01/20171
      19/01/20171
      26/01/20171
      Total176

       

      thanks a lot!