Search results

  1. D

    Excel Remove duplicates like for Collections using code stage

    Hi, I have the following situation: a collection with 7 columns and variable number of rows. I would like to remove duplicate rows by only consider 2-3 of those columns, exactly as it is done by Excel. I would like to avoid writing the collection to Excel, use VBA code and get it back to BP, so...
  2. D

    How to get a value from collection variable column?

    Hi, I would like to get a value from a collection column but this column can be a variable that is input from a data item, something like: [CollectionA.ColumnXX]. where XX comes from a Data Item. I tried concatentation in a Calculation Expression but it bring just a text value...
Top