skip 1 column from generation
TheHartz
Posts: 4 New member
I got a table with say 3 columns I want to generate 2 columns and leave 1 unchanged is that possible
Tagged:
Best Answer
-
Kurt_M Posts: 197 Silver 1Hi @TheHartz,
Apologies for the delay.
There's a possibility you can make use of the "Use Existing Data Source" when populating data. Essentially, it works by selecting the data from another table to populate the table you have selected, for the purpose of not overwriting the data you want to keep. This means you have to create a second table with the same data that's in the first table.
The reason you'd have to do this, is because if you stay with the normal option of generating data, it will delete/truncate the already existing data. The way I have suggested allows you to populate the columns that would otherwise be overwritten to NULL, with the data from the duplicated table.
In my instance I have 2 separate tables, lets call them Table1 and Table2. I have duplicated the data from Table1 into Table2, and on the generator, I have specified that I wish to pull the data from Table2. This then allows me to specify in column 3, that I wish to insert the data from the Table data. The other 2 columns can then have their data generated as per normal.
active_flg is the column I wish to remain using the data that's already in there. house_id and house_desc is something I'll let the generator create.
Here is the documentation for this:
https://documentation.red-gate.com/sdg/using-existing-sources/mapping-sql-tables-or-views
Kind regards,
Kurt McCormick
Product Support Engineer, RedgateNeed help? Take a look at our Help Center
Answers
You can make use the of the "Use Default Values" option. Select the column in question and then choose this option in the drop down.
Kind regards,
Kurt McCormick
Product Support Engineer, Redgate
Need help? Take a look at our Help Center
I Think I was not clear enough, what I intended to was to keep the old data, I’ve tried this but het result is the default data in this case NULL and I want to keep the original data value