Copy contents of Container field to different table

[Matt Malyschko]

I am trying to copy the contents of a container field from one table to a new record in another.

 

Is there a way to do this without finding the specified record, then importing that table into the second table?

[Matt Malyschko]

Additionally, if this is the only approach, how do I script it to select the correct table to import from? I cannot seem to find this...

[Wim Decorte]

You mention both copy and import... can you explain a bit more what exactly you want to do?  To get content from one field to another typically does not use either copy or import, but the "set field" script step.

 

Without knowing the purpose, the fact that you will have the same data in two different records sorta goes against the normalization principles...

[Matt Malyschko]

You mention both copy and import... can you explain a bit more what exactly you want to do?  To get content from one field to another typically does not use either copy or import, but the "set field" script step.

 

Without knowing the purpose, the fact that you will have the same data in two different records sorta goes against the normalization principles...

 

I have a record in one table, that contains a Container field, that I need to then duplicate into another table.

 

Previously, I had been setting all the fields as variables, and then move to the new table, create a new record, and set the appropriate fields from the variables.

 

However, I cannot do this with container fields.

 

If I find the specified record to make it the only record in the found set, and then manually import it to the new table, it is fine. However, I cannot figure out how to script this, to select the table to import from within the file.

 

While writing this, I figured I could set a global container variable, and store the container info there, while the rest uses variables.

[Wim Decorte]

While writing this, I figured I could set a global container variable, and store the container info there, while the rest uses variables.

 

That's the approach that I would recommend.