Ok so I have two tables. Table A and Table B.

Table A has 2 fields, Field A and Field B. Field A is a data point, and Field B is a category.

Table B has 1 field, Field C which is a data point.

I want to write a script that Creates 1 record in Table B for every record in Table A that match a specified category in Field B and copy the data from Field A to Field C for each new record in Table B.

Example: Table A has 10 records. 5 of those records have the value "X" in Field B. For each record in Table A with a value in Field B of "X" The script would create a new record in Table B and copy the content of Field A to Field C. End result would be in Table B you would have 5 new records with the data copied from Field A into Field C.

I think this can be done in a similar fashion to the methods used to find duplicate records via a self join relationship and a looped script step. But I'm still a bit of a noob and can't get it figured out.

Hope this makes sense. Can anyone help out?

Please, rephrase your question. See here how and why:

http://fmforums.com/forum/showpost.php?post/228583/