Copy columns from collection

[polinenileela_b]

Hi , I am getting my collection from my DB , now I want to get only 2 columns from my collection , sort them so no duplicate copy then I want to copy in to my excel 1. I want to get only 2 columns from collection 2. I want to sort them so no duplicate codes ( I shld not use sql query .. only use my library to do ) 3. Can I use get cell and copy these values ? Thanks ..

[John__Carter]

Would it not be easier to change the query to give you the DISTICT data you need? Alternatively, create a new code stage with these two lines: Dim v As New System.Data.DataView(Collection_In) Collection_Out = v.ToTable(true, Column_Names_CSV.Split("",""))

[Denis__Dennehy]

Have you looked at and experimented with the utility VBO's that are distributed with the Blue Prism product? I think the answer to your problem is probably in there somewhere. Maybe you could delete all the columns from the collection you don't want, they use the sort action? Then in the excel object you probably want to use either the write collection action or the paste action?? Every use case is a bit different but I bet the answer is in those utility objects if you experiment with them.