Generate a full name for a column

shawn_collymore

I want to generate a full name for a column but leave it blank if another column is also blank.

Jessica R

Hi @shawn_collymore,

You can create a Python script for the column based on the other.

For more on the Python Generator: https://documentation.red-gate.com/display/SDG3/Generic+generators#Genericgenerators-PythonscriptgeneratorPythonscriptgenerator

For Python script examples: https://documentation.red-gate.com/display/SDG3/Example+Python+scripts

Hope that helps!

shawn_collymore

I know that you can create a Python script for the column based on the other. That was why I was asking. I look at the different python script examples and could not see how to do it.