Replace Value in Collection & Reorder Columns

Many of us want an easier way to reorder columns in Collection and replace a specific value inside the collection in Blue Prism. The attached code does just that.

Problem Statement:

Reorder Collection Fields.


Main Collection,

A Collection containing proper order or Columns.


New Collection with reordered columns.


Problem Statement 2: 

Replace a certain value inside a collection by some other value (Or replace blanks inside collection to some other value).


Main Collection

The value to be replaced

The new Value



The new collection with replaced value.