Link information between tables

Powerful and fully customizable utility that generates data for database testing purposes

Moderator: Support Team

Link information between tables

Postby Felipe H. » Fri Jun 17, 2011 1:27 pm

I have 2 related tables that I need to fill with information, but I need that the information created match with the information I have in the other table, that is:
In the source table I have User1 that have a GUID 001 with the address, phone number, first name, last name, etc. and in the table2 I need to put the GUID and bring the same information to the same fields on the new table but it must be the same.

So I tried with the fill from table option but when I try to do the link with the clause where guid = @’GUID’ it doesn’t work at all, nor the functions $table or $query.

Could you help me with this?

Felipe H.

Re: Link information between tables

Postby Support Team » Fri Jun 17, 2011 3:04 pm

Please try to:
1) populate the first table. I've called it 'Table1' in sample query below.

2) use "by pattern" fill method with following pattern:

$QueryGroup($QueryGroup(1,(select GUID,Address,Phone... from Table1))

for the first column of the second table that must contain same information block.
Of course you should modify table name and column list in the query.
"1" is number of the group of columns.

3) use "by pattern" with $Group(1,2) for the second column, $Group(1,3) for the third, etc.
Support Team
Posts: 259
Joined: Sun Mar 26, 2006 3:48 pm

Return to DTM Data Generator, Flat File Generator and Test XML Generator

Who is online

Users browsing this forum: No registered users and 1 guest