3 Replies Latest reply: Nov 2, 2017 5:01 AM by Victor GREFFET RSS

    Crossing data with condition

    Victor GREFFET

      Hi community !

       

      I'm looking for a way to merge 2 columns depending on the title, I mean :

      What I have :

       

      Document titleBaselineDate1BaselineDate2
      Document1

      date

      Document2date
      Document 3date
      ....date
      ....date
      ....date
      ....date
      Document n-1
      Document ndate

       

      What I want :

       

      Document titleBaselineDate1BaselineDate2BaselineDate
      Document1

      date

      date

      Document2datedate
      Document 3datedate
      ....datedate
      ....datedate
      ....datedate
      ....datedate
      Document n-1'empty'
      Document ndatedate

      Knowing that when you have a date in BaselineDate1, BaselineDate2 is empty.

       

      Furthermore it would be nice to have 'empty' for documents without date and keep the column BaselineDate1 and BaselineDate2 in my DATA

      I tried with a left join and an if condition but without success,

      Do you have an idea ?

       

       

      Thanks !!

      Victor