Is If-Then-Else logic possible
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!