When one or more available columns are dropped or otherwise selected into an existing Text/String Literal or Parameter element in the tree, one of the following pop-up menus is displayed depending on the number of columns being applied and whether any values are already present. The same will occur if one or more columns are dropped into a text box on the Properties dialog for these same elements.
One column selected and empty text/string literal:
- Set text equal to value
- Replace this SQL element (i.e., replace literal element with column)
- Cancel
One column selected and text in text/string literal:
- Replace text with value
- Add value to list
- Replace this SQL element (i.e., replace literal element with column)
- Cancel
Multiple columns selected and empty text/string literal:
- Set text equal to list of values
- Cancel
Multiple columns selected and text in text/string literal:
- Replace text with list of values
- Append list of values to text
- Cancel