cancel
Showing results for 
Search instead for 
Did you mean: 

How to delete Empty Columns in Collections

AparnaMenthum
Level 3
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..
14 REPLIES 14

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

AmiBarrett
Level 12
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
Level 3
Sorry @ amibarrett I am unable to catch your point.

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

AparnaMenthum
Level 3
Got it, Thank you..@amibarrett