Is If-Then-Else logic possible

papademuchos

Suppose I have two columns and I want column 2 to be based on the random value from column 1.  For example, column 1 is Yes|No.  I'd like column 2 to be 1 when column 1 = Yes and 0 when column 1 = No.  Is this possible?  I am new to regex expressions and tried to search online for examples, but what I found doesn't seem to work in SQL Data Generator. 

Thanks for your help and suggestions!

Russell D

We don't really have much to help here unfortunately. https://documentation.red-gate.com/sdg/using-generators/generic-generators#Genericgenerators-Regexpgenerator has a few basic pointers but doesn't sound like it's going to help.

(?ifthen|else) though does exist in regex. Try https://www.regular-expressions.info/conditional.html as a resource.