1. Add multiple columns to your SQL query

  • Text: Displayed in the replace dialog to help the user select the correct data set

  • Replacement: Replacement for the Placeholder

  • Additional Replacement: Each value will be mapped to a optional Placeholder defined in the Placeholder Macro

The Description will help to fill out optional Placeholders in the Placeholder Macro

2. Add a Placeholder Macro to your template

The description can now help to fill out the optional/additional Placeholders

It doesn’t matter which one is the primary Placeholders,

It is also possible to only use the first additional Placeholders or none at all, but the order has to be the same as it is in the SQL query. The additional Placeholders are optional.

3. Instantiate your template

Now only the primary Placeholder will be displayed, and the first column of the SQL query (Text) appears to help select the replacements.

The other two additional Placeholders are filled out automatically in the background

4. Result

All three Placeholders are now replaced