Building Fields from Generated Fields
jkrueger
Posts: 5
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
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