Using an Export to Update a field with existing description from another field
Hi,
I’m trying to figure out how to update a field using another field. In the Integration manual there is an example, using a fixed piece of text to do this, but I need to be more dynamic.
My example is taking the Transaction Description in Import Bank Transactions and updating that into Ext. Ref. Nbr.
Below is what I have so far, but it won’t do anything, so I know I’ve got the syntax incorrect. Has anyone done this in the past?
I have figured it out, so I had to post this for syntax purposes and for future head-banging.
The trick to this screen, as mentioned before, is the ID (CABankTrans.TransID) field. This is the Primary for the table, but a few rules on how to use it for updates.
- It is has to be included as the first field for Details
- Untick Commit
I found this whilst re-reading Troubleshooting Performance in Import and Export Scenarios in the help. There is a section about what commit is used for and how to speed up scenarios. In short because it is a field that can't be updated, it doesn't need to be committed, only used for a look-up when updating. By default it is ticked, so I trusted the system on that front. Once unticked, hey presto!!
Glad I stayed committed to the finding the answer :smileywink: