2 Replies Latest reply on Feb 19, 2017 10:00 PM by Christoph Kreibich

    Date Comparison between two data sources with if-else-statement

    Christoph Kreibich

      Hey guys,

       

      I am having trouble comparing date fields between two data souces. One of the sources contains information from a machine learning model (VAR_IMP) and the other one contains the values that were used to train the model. The idea is now to select the "most important" variables - as identified in the model - and see which values have been put into the algorithm.

       

      My ideas was to use an if-else-statement between the two data sources:

      IF ATTR([DATE])>= ATTR([MODEL].[DATE_FROM])

      AND

      ATTR([DATE])< ATTR([MODEL].[DATE_TP])

      THEN TRUE ELSE FALSE END

       

      But it doesn't seem to work as I only get FALSE back...

       

      Does anyone has a better idea on how to solve this problem?

       

      Thanks! Christoph