Overwrite Collection

[SaraanshArya]

I have two collections, Coll A and Coll B. Initially, both these collection have different fields and data. I want to overwrite Coll A with Coll B, such that finally both the collections are identical. Is this possible?

[John__Carter]

If B is undefined (ie has no defined fields) then a simple calc with the expression [Coll A] will work. But if B does have a predefined column structure, then you won't be able to set it using A, unless A has the same structure.

[SaraanshArya]

Yeah, I was referring to the latter case. Thanks for your help.

[NoahSommerfeld]

@Saraansharya, if you needed to, I think you could accomplish this dynamically using the Utilitiy - Collection Manipulation VBO that's comes with BP. Specifically use 'get Collection Fields' on Coll B, and then 'rename Collection fields' on CollA.  If the data types don't match, maybe merge/transpose to temporary Coll C?