Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set the same value for a multiple row in a table

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

4 Replies
anbu1984
Master III
Master III

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

Not applicable
Author

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
Master III
Master III

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';

Not applicable
Author

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.