CarlSeil
New member
- Local time
- Today, 04:40
- Joined
- Nov 30, 2020
- Messages
- 14
Trying to figure out if it's possible to add a column of data that I don't care how to match. Basically, I need to insert some sample data into a table to replace live data for a test. So basically I have live data:
Etcetera. And I have retrieved/generated a list of names I want to plop in there to replace:
So I'll basically trim the sample names to the same number of records. In the past, I think I have managed this by altering the two tables and adding an auto-increment field. Then I merge the two tables with a query that joins on the auto-increment columns. Is there a simpler way to do this without altering the tables? I obviously don't care which name goes where. I just want to end up with something that looks like:
ID | Name | Amount |
76543 | Venkataraman | $1,200.00 |
76532 | Mattarnovy | $720.23 |
76516 | Simak | $1,212.13 |
Etcetera. And I have retrieved/generated a list of names I want to plop in there to replace:
Smith |
Jones |
Wilson |
Peterson |
So I'll basically trim the sample names to the same number of records. In the past, I think I have managed this by altering the two tables and adding an auto-increment field. Then I merge the two tables with a query that joins on the auto-increment columns. Is there a simpler way to do this without altering the tables? I obviously don't care which name goes where. I just want to end up with something that looks like:
76543 | Smith | $1,200.00 |
76532 | Jones | $720.23 |
76516 | Wilson | $1,212.13 |
Last edited: