I am using wM 6.0.1 and the JDBC adapter service to select a format for an email message I would like to send out. When I get the format from the database, I want to be able to combine the format with the values in the pipeline to perform variable substitution for my email message. I want to be able to modify the format in the database to modify what goes into my email (what fields from the pipeline):
database field: format= %email/subject%%email/body% where email is my document name.
I populate the document, EMAIL, with values and I want to be able to do something like a MAP step using variable substitution to combine the format with the values from pipeline.
Has anyone done anything like this? I can’t get the variable substitution to work.