Loop Through Values in a Different Tabel

I have a table that has two fields. We’ll call the table Table One and the two fields Name and Diameters (note the plural form). The name field is a simple string. The Diameters field is a list (or array) of values. As a simple example:

  • Name: “Widget”; Diameters: “1, 2, 3, 4”.

Now, I want to create another table – we’ll call it Table Two. Table Two also has two fields: Name and Diameter (note the singular form).

What I want to do is create a unique entry for each diameter in the Diameters field in Table One. So, Table Two would look like this:

  • Name: "Widget; Diameter: “1”
  • Name: "Widget; Diameter: “2”
  • Name: "Widget; Diameter: “3”
  • Name: "Widget; Diameter: “4”

In other words, I want to loop over each value inn the Diameters field in Table One and use that value to create a new entry in Table Two.

I am not sure, though, how to do this. Do I need to use the Scripting Block? Is it possible without the Scripting Block? Either way, how would I do it?

Thanks.

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.