Options
How to generate a ColumnX in Table2 based on ColumnY from Table1
Jozef
Posts: 1 New member
Hi Guys,
I'm new here and I tried to find answer to my question, but without success .... I was able to find similar question, but there wasn't answer or any solution. Provided solutions are working only with already existing data, there is not (or I haven't found) solution for clean empty database.
I've got empty database and I want to generate data into it to have decent data set to work with. Partial model is:
Scheme:
ID [PK]
HomeURL
CustomerDetails:
ID [PK]
Title
SchemeID [FK]
CustomerURL -> this column should be combined from Scheme.HomeURL+CustomerDetails.Title
Example...
Scheme:
35, https://example.com/product/
55, https://example2.net/product/
CustomerDetails:
1135, Customer9875, 35, https://example.com/product/Customer9875
7515, Customer3543, 55, https://example2.net/product/Customer3543
Do you have any suggestions or solution how to achieve this, PLEASE?
Thanks in advance.
I'm new here and I tried to find answer to my question, but without success .... I was able to find similar question, but there wasn't answer or any solution. Provided solutions are working only with already existing data, there is not (or I haven't found) solution for clean empty database.
I've got empty database and I want to generate data into it to have decent data set to work with. Partial model is:
Scheme:
ID [PK]
HomeURL
CustomerDetails:
ID [PK]
Title
SchemeID [FK]
CustomerURL -> this column should be combined from Scheme.HomeURL+CustomerDetails.Title
Example...
Scheme:
35, https://example.com/product/
55, https://example2.net/product/
CustomerDetails:
1135, Customer9875, 35, https://example.com/product/Customer9875
7515, Customer3543, 55, https://example2.net/product/Customer3543
Do you have any suggestions or solution how to achieve this, PLEASE?
Thanks in advance.
Tagged:
Answers
Welcome to the community.
You might be able to get some advice from our members.
This does look like a question that one of Support engineers might need to investigate for you though.
If you've a got support contract, please send us a ticket. Provide as much information as you can - screenshots of any errors, log files etc – so we can help you as fast as possible.
If you're not covered by a Support contract at the moment, email our Sales team at sales@red-gate.com, and they'll be able to help.
Alternatively you can check out the product documentation from my link below.
https://documentation.red-gate.com/sdg4
You can put in specific search terms in the top-right hand search bar.
Kind regards
Redgate Software