How to delete Empty Columns in Collections

[AparnaMenthum]

Hi All,   I am Working on Excel data, Copying all Excel data in to collections. Once I copied all data in to collections it is copying extra empty columns also, I want to delete column extra columns in collections. I tried business object Utility-Collection manipulation using Delete column action. By using this action I can able to delete only one column, I want to delete 3 columns. If any one knows solution Please help me..   Thanks in Advance..

[AparnaMenthum]

Placed 'Next' below the End If, It's working but how to use initialize stage in the process studio.

[AmiBarrett]

You don't call it like an action, it's just built in. If it compiled fine in the global code section, then you should be able to invoke the function RemoveEmptyColumns in any code stage on any action you create in that same object.

[AparnaMenthum]

Sorry @ amibarrett I am unable to catch your point.

[AmiBarrett]

If that code is in your global code, you should be able to call RemoveEmptyColumns(Collection) in any code stage.

[AparnaMenthum]

Got it, Thank you..@amibarrett