AnsweredAssumed Answered

How to combine multiple "like" items into one item

Question asked by gbaker88 on Oct 16, 2015
Latest reply on Nov 20, 2015 by gbaker88

Hi,

 

I currently have a list that has the following format:

 

ProjectID          COMP             Hours

Test1                    VEN               44

Test1                    VEN               36

Test1                    NOM               18

 

I am trying to run a workflow that will look at the values within ProjectID and COMP, and if they match up loop through the list to get one line.

Based on the example above the returning result would, hypothetically, be:

 

ProjectID          COMP               Hours

Test1                    VEN                    80

Test1                    NOM                    18

 

Would someone be able to assist in designing a workflow for this? I've tried querying the list with a collection operations, but feel like I am missing something.

 

Thanks in advance,

Greg

Outcomes