%Key field link tables

[Anonymous]

I am trying to connect two tables and the data is not a one to one connection.

Table one is structured as so:

Job#	Quote	Quote Cost
12345, 12346	500	$10,000
12347	300	$7,000

Table Two is structured as:

Job#	Actual Hours	Actual Cost
12345	550	$11,000
12346	520	$10,500
12347	200	$6,000

Is there a way to make The Jobs 12345 and 12346 with the , separator link to two different lines so I can pull the Quote values to compare?

Thank you.    

[sunny_talwar · Accepted solution]

Try this

LOAD SubField(Job#, ', ') as Job#,

     Quote,

     Quote Cost

FROM....

[Anonymous]

Thank you.