Is If-Then-Else logic possible

papademuchos · September 19, 2019 7:50PM

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 · September 23, 2019 1:25PM

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.

Is If-Then-Else logic possible

Answers

Product Learning

Community Forums

Events & Friends

Simple Talk