Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

change value with if statement


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

4 Replies
MK_QSL
MVP
MVP

What is your input tables?

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

Not applicable
Author

Can you not just join in the script ?

ie - table1:

     load * from data 1

join

     load * from data 2

Not applicable
Author

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

Thanks

manojkulkarni
Partner - Specialist II
Partner - Specialist II

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

Update Values in Resident table | Qlik Community