How to update the value of non-key column in TableView/LookupTable
Hi,
I have TableView/LookupTable and would like to have a new column which will be initially blank. After some process, this will be updated to some value.
Example: Initial value of Category is all blank. Afterwards, those will be updated based from Country.
Employee | Country | Category
Aaron | United States | A
Bill | United States | A
Charlie | Canada | B
Thanks
Pegasystems Inc.
US
The LookupTable has a method called UpdateField which allows you to update the value of one row/column of data for a given key. You can also Call AddRecord again assuming you have the property UpdateOnDuplicateAdd set to True. This will essentially perform an Update if the record already exists.
-
PH
Thanks for your response.
I can't use UpdateField method since my criteria is a non-key column. The equivalent SQL statement for this is:
UPDATE Employee_Table
SET Category = 'A'
WHERE Country = 'United States'
If AddRecord will be used, correct me if I'm wrong, I believe this means looping through the LookupTable and calling AddRecord method multiple times until all records are updated.
Is there other way to achieve this? Please help..
Thanks!