- 17.9K All Categories
- 3.3K Industry Applications
- 3.2K Intelligent Advisor
- 59 Insurance
- 534.1K On-Premises Infrastructure
- 137.6K Analytics Software
- 38.5K Application Development Software
- 5.3K Cloud Platform
- 109.1K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 70.8K Infrastructure Software
- 105.1K Integration
- 41.5K Security Software
overwriting an ICP Target
i need to overwrite Target ICP based on the HFM account ICP attribute.
While i could do a manual explicit mapping, this is not very handy nor dynamic.
I was thinking about creating a AftValidate script to overwrite the Target ICP.
Now i know how to retrieve the IsICP attribute from HFM and compare it in a loop to the ACCOUNTX in FDM, but what is the right way to overwrite a single value in an existing row?
i know how to add new records but i do not know how to update existing ones...so i thought something like the following could solve the issue, just i do not know the right syntax...
Set NewRec = DW.DBTools.fCreateRec()
.varKey = z
.colFlds.update "ICP", ICP