Building Data from Generated Data

jkrueger

I need to create data that is based on combinations of other generated columns. For example:

3 generated fields:
Field1 = "ABC"
Field2 = "XYZ"
Field3 = "123"

2 fields based on the above:
Field4 = "ABCXYZ" (Field1 + Field2)
Field5 = "XYZ123" (Field2 + Field3)

When I try to do this using a Python script for Field4 and Field5 I recieve an error that "The Value '' cannot be inserted" even though the destination field allows NULLs. What is the best way to accomplish this?

Thanks,
J

jkrueger

I've been in touch with Red Gate Support who have stated this is a known issue with the suggestion of generating fewer rows. I've had some success in converting Python scripts to simple expressions instead.