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.

Input:

Main Collection,

A Collection containing proper order or Columns.

Output:

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).

Input:

Main Collection

The value to be replaced

The new Value

 

Output: 

The new collection with replaced value.