cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
mai-kel
Nintex Newbie

Extract multiple choice column into collection variable for further processing

Jump to solution

Hi community,

I have a multiple choice column ("Fachabteilungen") which I need later in my workflow to address tasks:

Therefor I need to extract the input of this column, result should be this

Fachabteilung 1

Fachabteilung 2

Fachabteilung 3

I did the following:

1. Query list and write into a collection variable colFachabteilungen

   Result: colFachabteilungen AFTER QUERY LIST: [["Fachabteilung 1","Fachabteilung 2","Fachabteilung 3"]]

2. Regular expression Split collection variable colFachabteilungen

   Result: colFachabteilungen AFTER SPLIT: ["[[\"Fachabteilung 1\"","\"Fachabteilung 2\"","\"Fachabteilung 3\"]]"]

3. Regular expression Extract collection variable colFachabteilungen

   Result: colFachabteilungen AFTER EXTRACTION: ["\"[[\\\"","\"\"","\"\\\"","\"\"","\"\\\"","\"]]\""]

So I received the direct opposite of what I wanted.

 

Labels: (1)
0 Kudos
Reply
2 Replies
emha
Nintex Newbie

Re: Extract multiple choice column into collection variable for further processing

Jump to solution

I believe you need to

- query list just like as you do

- set up for each loop

- within the loop, get an element from collection

- process the element

with regular expressions you just turn one collection into another collection

0 Kudos
Reply
mai-kel
Nintex Newbie

Re: Extract multiple choice column into collection variable for further processing

Jump to solution

Yeah, that is exactly what I did in the meantime!

  1. Query
  2. Loop
  3. Get item from collection (COLL -> TEXT)
  4. Process text with replace string action

Cheers

mai-kel

0 Kudos
Reply