Recent content by Burks

Were you able to resolve this? I'm going to be doing something similar when I get permissions to the mailbox

Thanks Sahil. For anybody having this issue, just use Sahil's code but swap the columns round: Collection_3 = Collection_2.AsEnumerable().Except(Collection_1.AsEnumerable(), DataRowComparer.Default).CopyToDatatable() This returns unique values Collection_3 =...

I'm new to BP - would you mind expanding on how I declare the variables for the data items for the collections please? I know I need to do it in the Global Code area but can't figure out how.

Hi, As part of a larger process I need to sort through Collection A which contains around 5,000 rows at a time against Collection B which can contain a small amount of rows from around 10-30 and if any of the values from B match A then the rows from A need removing. I have attempted this by...

Going to jump on the bandwagon here. I need to loop through a collection of around 5000 rows and check against a second collection of about 8 items to see if there's any matching items in the larger collection - if so then they need removing. Can anybody suggest a good way of doing this please...

Hi, Is it possible to take the rows of data from a collection and concatenate them all into individual rows in a data item? I've tried looping over the collection in a calculation stage but this simply overwrites the value in the data item each time rather than creating a new line and...