Changing one specific field in table

[#1]

Hi all,

I am rather new in qlikview development so I have one question for you.

I have a table of partners and each of the partners (PAR_ID) is connected with currency via CUR_ID. During my analysis I realized that for some partners I have incorrect currencies in DB and I would like to change that in Qlikview Model directly. What I wanted is to apply the following function:

if(PAR_ID=39, VAL_ID=4, VAL_ID)

explanation: if PAR_ID=39 set VAL_ID to be 4, otherwise keep original VAL_ID

Since this is the fist time I'm doing this, normally it did not give expected results.

Can you please advise me how to implement this.

Regards

Vera

[sunny_talwar]

Try this:

If(PAR_ID=39, 4, VAL_ID)

[Kushal_Chawda · Accepted solution]

try this

LOAD *,

if(PAR_ID=39, 4, VAL_ID) as VAL_ID

FROM table