Generate data for derived column

sbendayan

Greetings,

I need to populate test data for certain columns which are derived from other columns in the same table. What is the best way to do this?

For example, I have a column that is derived by concatenating the values of 7 other columns in the same table.

Thanks,

SB

Andrew P

Thanks for contacting us!
It might be better to use a Computed Column instead of SQL Data Generator- Data Generator cannot do single column generation - it does whole rows.
https://msdn.microsoft.com/en-us/library/ms188300.aspx
If you do want to generate new rows, or delete the current records and insert new ones, then you can concatenate like that using the "Simple expression generator" https://documentation.red-gate.com/display/SDG3/Generic+generators

Do let me know if you have any questions or issues with that!

Warm Regards,