🕷️ Crawler Inspector

URL Lookup

Direct Parameter Lookup

Raw Queries and Responses

1. Shard Calculation

Query:
Response:
Calculated Shard: 138 (from laksa071)

2. Crawled Status Check

Query:
Response:

3. Robots.txt Check

Query:
Response:

4. Spam/Ban Check

Query:
Response:

5. Seen Status Check

ℹ️ Skipped - page is already crawled

📄
INDEXABLE
CRAWLED
2 months ago
🤖
ROBOTS ALLOWED

Page Info Filters

FilterStatusConditionDetails
HTTP statusPASSdownload_http_code = 200HTTP 200
Age cutoffPASSdownload_stamp > now() - 6 MONTH2.2 months ago
History dropPASSisNull(history_drop_reason)No drop reason
Spam/banPASSfh_dont_index != 1 AND ml_spam_score = 0ml_spam_score=0
CanonicalPASSmeta_canonical IS NULL OR = '' OR = src_unparsedNot set

Page Details

PropertyValue
URLhttps://forum.uipath.com/t/multiple-values-in-single-column-to-queue/414873
Last Crawled2026-02-18 12:19:23 (2 months ago)
First Indexed2025-09-24 01:35:09 (7 months ago)
HTTP Status Code200
Content
Meta TitleMultiple values in single column to queue - Studio - UiPath Community Forum
Meta DescriptionInformation 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 Canonicalnull
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 [![image](https://global.discourse-cdn.com/uipath/optimized/4X/c/b/8/cb8d2e0e72f36819a2eaf21d669184c797342b30_2_690x87.png)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 ![grafik](https://global.discourse-cdn.com/uipath/original/4X/8/4/0/840030afbe3c263dd72f70d3a8795c6c72966ef6.png) [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 ![](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/sathish_kumar_s/48/231419_2.png) 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 ![grafik](https://global.discourse-cdn.com/uipath/original/4X/0/9/a/09a76e859965520870c97211201cb6880a67afc4.png) So we can pass it to a for each with set typeargument to string ![](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/sathish_kumar_s/48/231419_2.png) Sathish\_Kumar\_S: > ADD all the user unique names in website maybe distinct will help us ![grafik](https://global.discourse-cdn.com/uipath/original/4X/a/4/5/a458398fbd83bc3235b18349c849cb5a5b4b1df0.png) [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 ![](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/sathish_kumar_s/48/231419_2.png) Sathish\_Kumar\_S: > from QUEUE we assume as QueueItem, right? [![grafik](https://global.discourse-cdn.com/uipath/optimized/4X/d/e/0/de07ffb534c1eaa489c30fd4ba05661e4939b1b5_2_690x355.png)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 [![image](https://global.discourse-cdn.com/uipath/optimized/4X/a/6/a/a6afcc73a32b06c690f28229a0aed6c096ad7279_2_690x128.png)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) ![image](https://global.discourse-cdn.com/uipath/original/4X/7/6/0/76081045cccd42c6586e9bd6f50d160e053eb692.png) [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 [![image](https://global.discourse-cdn.com/uipath/optimized/4X/4/0/4/4048cfea8f11afc9fbf937b4b56b43b4ae65df2e_2_690x116.png)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 Markdownnull
ML Classification
ML Categoriesnull
ML Page Typesnull
ML Intent Typesnull
Content Metadata
Languageen
Authornull
Publish Time2022-04-13 09:41:01 (4 years ago)
Original Publish Time2022-04-13 09:41:01 (4 years ago)
RepublishedNo
Word Count (Total)629
Word Count (Content)378
Links
External Links6
Internal Links27
Technical SEO
Meta NofollowNo
Meta NoarchiveNo
JS RenderedNo
Redirect Targetnull
Performance
Download Time (ms)379
TTFB (ms)369
Download Size (bytes)9,997
Shard138 (laksa)
Root Hash4015940174418954138
Unparsed URLcom,uipath!forum,/t/multiple-values-in-single-column-to-queue/414873 s443