What are the challenges you face when working across database platforms? Take the survey
Options

Building Fields from Generated Fields

jkruegerjkrueger Posts: 5
edited February 5, 2015 2:49PM in SQL Data Generator
I have a need to create data for a table that has several fields containing the same data in different format. For example:

Field1 = "ABC"
Field2 = "XYZ"
Field3 = "123"

Field4 = "ABC XYZ" (Field1 + " " + Field2)
Field5 = "123 XYZ" (Field3 + " " + Field2)

I had hoped to generate Field1, Field2 and Field3, and then use a Python script to concatenate the generated fields, however I receive the error "The value '' cannot be inserted into column Field4" whenever data is generated, even though the destination field allows NULLs. What is the best way to accomplish this?

Thanks,
J
Sign In or Register to comment.