How can we help you today? How can we help you today?

Building Data from Generated Data

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
0

Comments

1 comment

Sort by
  • 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.
    jkrueger
    0

Add comment

Please sign in to leave a comment.