change value with if statement

[#1]

Hello together,

I have 2 Tables <Items> and <Pflichtartikel>

When I load the table <Items> it should compare, if the ITEMID exist in the table <Pflichtartikel>.

If so, then the Value NULL should be changed to the value of the ItemId.

The result should look like

ItemId       pflicht

CDR    URA

Tinte    <null>

Toner  <null>

USB-Stick URA-1

Festplatte <null>

PC        <null>

DVD     URA

URA     URA

URA-1  URA-1

Thanks fo help

puwo

[MK_QSL]

What is your input tables?

On what basis you want to compare Itemids...?

[#3]

Can you not just join in the script ?

ie - table1:

     load * from data 1

join

     load * from data 2

[#4]

No, I can't. Because I have only to change the value "pflicht" if the ItemId is in the second table.

Thanks

[manojkulkarni]

Pls check below link, will help in updating resident table values.

Update Values in Resident table | Qlik Community