Need to give default values to a specific output file columns.
My question looks simple, however after hours working this great tool, I didnt find a solution. I already have a template file to be imported into a new system where will be filled with the data from MDB file after a cleanning & formatting process (address, phone, zip, email address...) But the template file (target) contains columns that the MDB file (source) dont have it.
Both are declared as DataStores (target and source) The cols are necessary, like Customer = True, or Active= True; Almost are boolean values.
I didn´t find the way to create a VAR (boolean) to be asigned in the write process to a specific columns.
The only idea that I have right now is lunch another Job with the result file to be treated again.
Let me know if there is a way to do in the same Job an autofilled of those columns.