How to combine multiple \like\" items into one item"

Any thoughts?

Thanks,

Greg

Hi Caroline,

Thank you for the response. I am fairly new to this so am trying to follow step-by-step here. On the second query "Then perform another query to your list to get the other items which have the same ProjectID and COMP.", how am I suppose to set that query? In the past I've tried setting where ProjectID is equal to ProjectID and COMP is equal to COMP, but I think I'm missing something.

Currently, I have Loop (without a condition attached) > Query List with a filter of ID is greater than FN-MIN(Workflow Variable), sorted ascending > Set WF Variable to ID

For the first Query am I suppose to store each field in a unique variable as well (hours, COMP, ProjectID)?

I think gathering that information would help with the start of this, then I'll be able to look at the following steps after.

Thanks,

Greg

Thanks again! Running in to another snag - I am unable to set the Number WF variable to FN-Min ID. The ID field doesn't allow for that to occur.

-Greg

Thanks Jung - I was able to get two columns to add up, but was never able to get to the third value (probably due to my limitations on this).

It turns out the process has flipped and I am looking to do this in a different way now. If I need to create another discussion I can do so, but wanted to try here first.

I have a text String from one list that needs to have "like" values combined and created in another list. The fields you see below are part of a choice field (multi-select), if the values have the same COMP (value in center with caps) and role (value to the right of COMP), then they need to be rolled into one item and the hours need to be summed, while at the same time the Colors need to be "joined".

Example:

With this value here the end result that we are looking for on the next list would be 3 lines:

Color                                   COMP                    Hours                          Role

Blue; Yellow; Pink                COMP                      196                       Consultant

Red                                       ALPHA                      14                        Analyst

Silver                                    COMP                        10                        Analyst

I've been trying to complete this with the Regular Expression, but am unable to break apart then add back together before creating the new list item.

Would you have any ideas on how to do this?

Thanks again!

Greg

Hi Greg,

No problem

When you say that you was unable to get 3 columns, are you talking about the query list action ?

What you'd like to do is more complicated now...

The values are only in one text field or are they in list items ?

Have you also built a form where the user can populate those values or these values comes from another system ?

ok, it's more clear now.

Do you have the possibility to store those value as XML in a text field ?

It will be easier to implement a solution with an XML.

Sorry it's a bit confused now.

what is this choice field : a SharePoint column or a workflow variable or something that comes from an external system ?

Do you execute a SQL query in the workflow ? If so, which information to get ?

ok I understand.

Unfortunately, it's complicated to do what you'd like to do.

The only way that I can imagine is to create a temporary list where you would add all the selected choices with one column for COMP, one for role and one for hours and do what I described in my previous answers...it would be lots of actions in your workflow and a temporary list but I don't know how you could do it differently.

Hi Greg,

You can maybe separate the treatment in several workflows (one workflow per field treatment) and call a workflow after another has terminated.

You can also take a look at Manfred's answer to this post, in can also help you :

Re: Nintex repeating section

Hope this helps

It should be available in all versions of Nintex Workflow. Maybe the administrator hasn't enabled the use of this action.

Well, splitting your workflow in several workflows should help you

no problem

Good luck

I can share the steps

1- Created separate Reg expressions to get the different string values.

2 - Created a For Each for each field and stored the results in a string

     A) Collection Operation below each For Each to add the previous strings to a Combined Collection

3 - Created another For each to store result in a separate string combined element, with a number combined index

     A) Reg Expression to Parse the string variable on the : and use the string combined element and input text with a new variable (string parsing having the results stored in it

     B) Collection Operation (3 of them - 1 for each, excluding hours) to pull apart the string based on the :. Created an Index with default values (programming looks at this as 0 being first occurrence, 1 being second, 2 being third and so on. Stored the result in a new variable for each

     C) Concatenated my two strings where I was looking for common values and stored result in a Combined String COMP_Role

     D) Collection operation to get hours (similar as above)

          a) Reg Expression (d+(?= Hours)) to extract hours out and store results in collection

          b) Collection operation to store hours into a string

     E) Col Op to see if my target collection Exists within string, store answer in Yes/No variable

     F) Condition to see if Yes/No value is yes or no. If No, Collection operation to add all previous collections from step B). If Yes, created another yes/no variable and set to no. Created loop counter which is then set to 0

     G) Still within the Yes side I created another For Each that is storing the Collection into another variable (with the appropriate index selected). Have it set to stop processing when my original yes/no in step F) is true.

     H) Set Condition - If any value from workflow data from new looping string equals original string. No, moves on. Yes, set loop values again.

     I) Set loop counter variables to 1

     J) 3 Collection Ops to Get all values from original collection (3 separate collections), with an index (indexes are key to ensure the right value is pulled in) and store result in string.

     K) Add hours from new string created in J) to original hours value - store in another num collection

     L) Remove previous entry from hours collection, with index setup

     M) Put sum of hours back in hours collection - Original Collection for hours Add to num collection from K) - Have index setup accordingly

     N) Concatenate the Solutions, between two collections created earlier and store result in concat solution string.

     O) Put Concat Solution back into solution counter (same concept as row M))

4) Set another variable "Create item counter" to 0

5) Create another For Each

     A) For each Collection store result in a string variable

     B) Col Opt to get a piece of that string by using an index (Create Item Counter - step 4) variable and store in a Create variable

     C) Since I have everything separated besides the COMP_ROLE I need to create a Regex to split at the : and store in a new variable

     D) Create 3 more COL Operations for each individual piece of the string and index according and store in new create variables

     E) For any field that requires the items to be combined rather than joined you'll need to Replace the text. Mine were separated by a comma initially and SharePoint would treat that as one giant string and I want multiple strings (so it would appear in a choice field as being different selections). To do this use replace text and put in ;# into the replacement text and store result in another create item

     F) Create Item in new list.

Hope that helps!

-Greg