6 Replies Latest reply: Apr 24, 2015 11:21 AM by adam linden RSS

    if in data load editor

      Hi, I'm having some issues with my if statements again, this time I'm in the data load editor attempting to flag if DATE3 is the same as either DATE1 or DATE2. What I think my problem is that DATE3 is from a different table than DATE1 and DATE2 so I get an error when I attempt to make the if-statement in either of their load locations.

       

      LOAD DATE1,

        DATE2,

          DATE3,

          date (DATE1),

          date (DATE2),

          date (DATE3),

          if (DATE1 = DATE3, 1, 0) as NEW,

          if (DATE2 = DATE3, 1, 0) as CLOSE

       

      I convert them to dates just because they specify an en exact time of day, which makes the comparison unnecessarily precise.

       

       

      Thanks in advance