Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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
MVP
MVP

Re: change value with if statement

What is your input tables?

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

Not applicable

Re: change value with if statement

Can you not just join in the script ?

ie - table1:

     load * from data 1

join

     load * from data 2

Not applicable

Re: change value with if statement

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

Thanks

manojkulkarni
Valued Contributor II

Re: change value with if statement

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

Update Values in Resident table | Qlik Community

Community Browser