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?