I've created a handful of Workbench jobs over the past few months, but every time I do, I seem to have to struggle for about an hour each time to get the replacement variables working with the 'Append' update method. This typically includes trying every imaginable order of operations, deleting and recreating the job multiple times, etc. until I finally stumble upon some way of making it work. I even went so far as to write down the exact steps I took last time I was able to successfully get it to work, but it's not working for me this time. Below are the steps I'm taking and a sample of the query I'm using.
- Create the job
- Set update method: Replace
- Create the replacement variable (TransactionID)
- Leaving the replacement variable out of the WHERE clause of the query, close and save
- Run the job
- Change the update method to 'Append'
- Check the replacement variable (This is where it's currently failing; replacement variable doesn't exist)
- Add the replacement variable into the WHERE clause of the query
- Save and run the job
Of course, since the TransactionID replacement variable doesn't stick, running the job again on step 9 fails. I could really use some help if anyone has any ideas.