ℹ️ Skipped - page is already crawled
| Filter | Status | Condition | Details |
|---|---|---|---|
| HTTP status | PASS | download_http_code = 200 | HTTP 200 |
| Age cutoff | PASS | download_stamp > now() - 6 MONTH | 2.2 months ago |
| History drop | PASS | isNull(history_drop_reason) | No drop reason |
| Spam/ban | PASS | fh_dont_index != 1 AND ml_spam_score = 0 | ml_spam_score=0 |
| Canonical | PASS | meta_canonical IS NULL OR = '' OR = src_unparsed | Not set |
| Property | Value |
|---|---|
| URL | https://forum.uipath.com/t/multiple-values-in-single-column-to-queue/414873 |
| Last Crawled | 2026-02-18 12:19:23 (2 months ago) |
| First Indexed | 2025-09-24 01:35:09 (7 months ago) |
| HTTP Status Code | 200 |
| Content | |
| Meta Title | Multiple values in single column to queue - Studio - UiPath Community Forum |
| Meta Description | 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 ( dif… |
| Meta Canonical | null |
| Boilerpipe Text | April 13, 2022, 9:41am
1
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
ppr
(Peter Preuss)
April 13, 2022, 9:54am
2
in general we can split by comma
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
ppr
(Peter Preuss)
April 13, 2022, 10:01am
4
maybe your feedback is misinterpreted. The split method is dynamic and not bound to a certain Length
So we can pass it to a for each with set typeargument to string
maybe distinct will help us
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)
Create Another variable named : FinalUserUniqueName = UserUniqueName.split({,},stringsplitoptions.removemptyentries)
Pass FinalUserUniqueName variable in For Each activity and activity that will add useruniqueuename inside for each ?
ppr
(Peter Preuss)
April 13, 2022, 10:32am
6
we assume as QueueItem, right?
yes it is a queue item…
Queue item will have key value like this
I have add System.Linq Namespace. But still Distinct command is not available ( Please refer below screenshot)
ppr
(Peter Preuss)
April 13, 2022, 11:17am
10
sometimes intelisense hangs. just continue as shown in the screenshot
Yes i have typed as per the screenshot… But expression expected warning
ppr
(Peter Preuss)
April 13, 2022, 11:22am
12
Typo Distict vs. Distinct() ← the n
transactionItem.SpecificContent("YourKey").toString.Trim.Split({","}, StringSplitOptions.RemoveEmptyEntries).Distinct()
1 Like
Awesome!!!. Thanks a lot for your response… It is working fine.
system
(system)
Closed
April 16, 2022, 11:57am
14
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed. |
| Markdown | [UiPath Community Forum](https://forum.uipath.com/)
# [Multiple values in single column to queue](https://forum.uipath.com/t/multiple-values-in-single-column-to-queue/414873)
[Help](https://forum.uipath.com/c/build/29)
[Studio](https://forum.uipath.com/c/build/studio/139)
[uiautomation](https://forum.uipath.com/tag/uiautomation)
[Sathish\_Kumar\_S](https://forum.uipath.com/u/Sathish_Kumar_S) (Sathish Kumar S)
April 13, 2022, 9:41am
1
[image940×119 49.3 KB](https://global.discourse-cdn.com/uipath/original/4X/c/b/8/cb8d2e0e72f36819a2eaf21d669184c797342b30.png "image")
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
[Forum Engagement Daily Reports](https://forum.uipath.com/t/forum-engagement-daily-reports/293853/416)
[ppr](https://forum.uipath.com/u/ppr) (Peter Preuss)
April 13, 2022, 9:54am
2
in general we can split by comma

[Sathish\_Kumar\_S](https://forum.uipath.com/u/Sathish_Kumar_S) (Sathish Kumar S)
April 13, 2022, 9:57am
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
[ppr](https://forum.uipath.com/u/ppr) (Peter Preuss)
April 13, 2022, 10:01am
4
 Sathish\_Kumar\_S:
> Sometime there will be more than 3
maybe your feedback is misinterpreted. The split method is dynamic and not bound to a certain Length

So we can pass it to a for each with set typeargument to string
 Sathish\_Kumar\_S:
> ADD all the user unique names in website
maybe distinct will help us

[Sathish\_Kumar\_S](https://forum.uipath.com/u/Sathish_Kumar_S) (Sathish Kumar S)
April 13, 2022, 10:27am
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 ?
[ppr](https://forum.uipath.com/u/ppr) (Peter Preuss)
April 13, 2022, 10:32am
6
 Sathish\_Kumar\_S:
> from QUEUE
we assume as QueueItem, right?
[grafik700×361 30.6 KB](https://global.discourse-cdn.com/uipath/original/4X/d/e/0/de07ffb534c1eaa489c30fd4ba05661e4939b1b5.png "grafik")
[Sathish\_Kumar\_S](https://forum.uipath.com/u/Sathish_Kumar_S) (Sathish Kumar S)
April 13, 2022, 10:38am
7
yes it is a queue item…
[Sathish\_Kumar\_S](https://forum.uipath.com/u/Sathish_Kumar_S) (Sathish Kumar S)
April 13, 2022, 10:46am
8
[image1246×232 13.6 KB](https://global.discourse-cdn.com/uipath/original/4X/a/6/a/a6afcc73a32b06c690f28229a0aed6c096ad7279.png "image")
Queue item will have key value like this
[Sathish\_Kumar\_S](https://forum.uipath.com/u/Sathish_Kumar_S) (Sathish Kumar S)
April 13, 2022, 11:16am
9
I have add System.Linq Namespace. But still Distinct command is not available ( Please refer below screenshot)

[ppr](https://forum.uipath.com/u/ppr) (Peter Preuss)
April 13, 2022, 11:17am
10
sometimes intelisense hangs. just continue as shown in the screenshot
[Sathish\_Kumar\_S](https://forum.uipath.com/u/Sathish_Kumar_S) (Sathish Kumar S)
April 13, 2022, 11:21am
11
[image1766×299 20.1 KB](https://global.discourse-cdn.com/uipath/original/4X/4/0/4/4048cfea8f11afc9fbf937b4b56b43b4ae65df2e.png "image")
Yes i have typed as per the screenshot… But expression expected warning
[ppr](https://forum.uipath.com/u/ppr) (Peter Preuss)
April 13, 2022, 11:22am
12
Typo Distict vs. Distinct() ← the n
```
transactionItem.SpecificContent("YourKey").toString.Trim.Split({","}, StringSplitOptions.RemoveEmptyEntries).Distinct()
```
1 Like
[Sathish\_Kumar\_S](https://forum.uipath.com/u/Sathish_Kumar_S) (Sathish Kumar S)
April 13, 2022, 11:57am
13
Awesome!!!. Thanks a lot for your response… It is working fine.
[system](https://forum.uipath.com/u/system) (system) Closed
April 16, 2022, 11:57am
14
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.
### Related topics
| Topic | | Replies | Views | Activity |
|---|---|---|---|---|
| [Adding distinct excel column name along with all filetered rows values of another column to one transaction in queue](https://forum.uipath.com/t/adding-distinct-excel-column-name-along-with-all-filetered-rows-values-of-another-column-to-one-transaction-in-queue/210815) [Something Else](https://forum.uipath.com/c/build/other-products/200) | 7 | 1298 | April 13, 2020 | |
| [How to add multiple rows of a DataTable grouped by a Column value into Queue as Single Queue Item](https://forum.uipath.com/t/how-to-add-multiple-rows-of-a-datatable-grouped-by-a-column-value-into-queue-as-single-queue-item/277553) [Help](https://forum.uipath.com/c/build/29) [excel](https://forum.uipath.com/tag/excel) , [activities](https://forum.uipath.com/tag/activities) , [question](https://forum.uipath.com/tag/question) | 2 | 1486 | December 23, 2020 | |
| [Add Multiline Excel Row data to Queue](https://forum.uipath.com/t/add-multiline-excel-row-data-to-queue/395599) [Studio](https://forum.uipath.com/c/build/studio/139) [studio](https://forum.uipath.com/tag/studio) | 2 | 723 | February 1, 2022 | |
| [Multiple input rows in single queue item](https://forum.uipath.com/t/multiple-input-rows-in-single-queue-item/494846) [Studio](https://forum.uipath.com/c/build/studio/139) [studio](https://forum.uipath.com/tag/studio) , [question](https://forum.uipath.com/tag/question) , [activities\_panel](https://forum.uipath.com/tag/activities_panel) | 4 | 1271 | November 30, 2022 | |
| [workQueue](https://forum.uipath.com/t/workqueue/106601) [Help](https://forum.uipath.com/c/build/29) | 8 | 1288 | April 4, 2019 | |
- [Home](https://forum.uipath.com/)
- [Categories](https://forum.uipath.com/categories)
- [Guidelines](https://forum.uipath.com/guidelines)
- [Terms of Service](https://www.uipath.com/legal/terms-of-use)
- [Privacy Policy](https://www.uipath.com/legal/privacy-policy)
Powered by [Discourse](https://www.discourse.org/), best viewed with JavaScript enabled |
| Readable Markdown | null |
| ML Classification | |
| ML Categories | null |
| ML Page Types | null |
| ML Intent Types | null |
| Content Metadata | |
| Language | en |
| Author | null |
| Publish Time | 2022-04-13 09:41:01 (4 years ago) |
| Original Publish Time | 2022-04-13 09:41:01 (4 years ago) |
| Republished | No |
| Word Count (Total) | 629 |
| Word Count (Content) | 378 |
| Links | |
| External Links | 6 |
| Internal Links | 27 |
| Technical SEO | |
| Meta Nofollow | No |
| Meta Noarchive | No |
| JS Rendered | No |
| Redirect Target | null |
| Performance | |
| Download Time (ms) | 379 |
| TTFB (ms) | 369 |
| Download Size (bytes) | 9,997 |
| Shard | 138 (laksa) |
| Root Hash | 4015940174418954138 |
| Unparsed URL | com,uipath!forum,/t/multiple-values-in-single-column-to-queue/414873 s443 |