9 Replies Latest reply: Mar 5, 2015 5:39 AM by Giovanni Scalzo RSS

    Replace the same value in a different row in a table

    Giovanni Scalzo

      Good morning,

      I have the following problem:

       

       

      In the table the field value DATA FATTURA is correct only where the value of the field CAUSALE is FE.

       

      How can I replicate this value in all areas where the field CAUSALE is different to FE?


      Data is retrieved from two different tables whose field of union is DATA FATTURA and NUMERO FATTURA..


      CNSIT:

          LOAD

              Num(CNNUFA,000000000) as [NUMERO FATTURA],

              CNCAUS as [CAUSALE],

              date#(CNDARS & CNDARA &'-'& CNDARM &'-'& CNDARG, 'YYYY-MM-DD'), 'DD-MM-YYYY') as [DATA FATTURA],

              date (date#(CNDTVI,'YYYYMMDD'),'DD-MM-YYYY') as [DATA INCASSO],

          FROM

      ...............

      (qvd);

       

      FADET:

      LOAD

          date (date#(DFDFA,'YYYYMMDD'),'DD-MM-YYYY') as    [DATA FATTURA],

          Num(DFNFA,000000000)    as    [NUMERO FATTURA],

      ...............

      (qvd);



      Thanks.

      Giovanni