how to update a field after load

[#1]

Hi all,

After loading a large table, I will need to select an individual record by "TRANS_NUMBER" and update "status" column with text. How do I do that? The transaction_number column values are alphanumeric.  And is there a way to select multiple records by TRANS_NUMBER and updating them all with the same status?

For example:

TRANS_NUMBER	Status
1347	Needs Action

I would like to change the Status of TRANS_NUMBER 1347 from Needs Action to Approved.

Thanks in advance for your help!

[Hemanth458]

where can i write this statement in qlik scripting part

UPDATE TransactionTable SET status='Approved' WHERE TRANS_NUMBER=1347;