Set the same value for a multiple row in a table

[#1]

Good morning, I would replace tha value of the field DATA FATTURA where CAUSALE = FE for each row.

The field DATA FATTURA must be the same of the value CAUSALE=FE for all the row.

How cai I obtain the result ?

Thanks

Giovanni

[anbu1984]

Tbl:

Load [NUMERO FATTURO],CAUSALE, [DATA FATTURA], [DATA INCASSO] From Table;

Join(Tbl)

Load [NUMERO FATTURO],[DATA FATTURA] As [DATA FATTURA FE] Resident Tbl Where CAUSALE = 'FE';

Use [DATA FATTURA FE] in the chart

[#3]

Hi Anbu, I have tried your solution but don't works.

My scripts is like this:

CNSIT:

    LOAD

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

        CNCAUS as [CAUSALE],

        if (match(CNCAUS,'FE'),date (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

XXXXXXXXXXXX

(qvd);

FADET:

LOAD

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

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

    DFCOM     as    [N° COMMESSA]

FROM

XXXXXXXXXXXX

(qvd);

[anbu1984]

Add where clause to this table

FADET:

LOAD

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

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

    DFCOM     as    [N° COMMESSA]

FROM

XXXXXXXXXXXX

(qvd)

Where CAUSALE = 'FE';

[#5]

The field CAUSALE does not come from the table on which I put the condition.

If I add the where clause it's not work correctly.

And it's wrong to add in the other section beacause I would show the value of the field CAUSALE where is the IN value.