Multiple values in single column to queue

Help Studio
1

image
image940×119 49.3 KB

Information from above EXCEL will be added to queue . ( multiple rows with different project details)

Our challenge here is the “UserUniqueName” column will have multiple values separated with comma in each row ( different project names)

We need to loop through these multiple values add the values one by one in the portal.

How to handle this multi value column in single transaction in queue & add values one by one in portal?

1 Like
2

in general we can split by comma
grafik

3

Sometime there will be more than 3 values and we need to loop (For each or something like this) through this values and ADD all the user unique names in website

4

maybe your feedback is misinterpreted. The split method is dynamic and not bound to a certain Length

grafik

So we can pass it to a for each with set typeargument to string

maybe distinct will help us
grafik

5

Please allow me explain what i understood from your response. Please correct me if i am wrong…

NOTE: Each row from excel will be added to orchestrator queue

1.Bot will fetch the “UserUnique Name” values ( separated with comma) from QUEUE and store in the variable ( Ex: UserUniqueName) ( Type String)

  1. Create Another variable named : FinalUserUniqueName = UserUniqueName.split({,},stringsplitoptions.removemptyentries)

  2. Pass FinalUserUniqueName variable in For Each activity and activity that will add useruniqueuename inside for each ?

6

we assume as QueueItem, right?

grafik
grafik700×361 30.6 KB

7

yes it is a queue item…

8

image
image1246×232 13.6 KB

Queue item will have key value like this

9

I have add System.Linq Namespace. But still Distinct command is not available ( Please refer below screenshot)

image

10

sometimes intelisense hangs. just continue as shown in the screenshot

11

image
image1766×299 20.1 KB

Yes i have typed as per the screenshot… But expression expected warning

12

Typo Distict vs. Distinct() ← the n


transactionItem.SpecificContent("YourKey").toString.Trim.Split({","}, StringSplitOptions.RemoveEmptyEntries).Distinct()
1 Like
13

Awesome!!!. Thanks a lot for your response… It is working fine.

14

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.