Search results

Thanks a lot VJR. I had to solve this a while back the hard way by pasting data in Excel, running a macro and reading it back. If I come accross a similar requirement in the future, I will five rhis a try as it seems much more easier (at least avoids to run a macro).

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

Actually I got it wrong the first time, your solution is not hard coding :) Now to provide more perspective, I have a collection A with n number of rows, I search on a fixed column in CollA for a value in another Collection B, if I find it, I need to retrieve the value on a column X in that row...

Thanks for the prompt response. Although this might work, I do not want to hardcode field names, as this is coming from a report that sometimes changes its titles. Based on that the other idea I had was to traspose each row into a new collection with one column and the iterate by row until the...

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