I have proble when i get excel file data to add in queue item data will be mismatch set in queue item

[MONALI_BHALERAO]

i want same as excel formate data to add as same in add queue item

[Pradeep_Shiv]

it’s in the same format!
right?

[MONALI_BHALERAO]

yes excel sheet data

[AshwinS2 (Ashwin S)]

Hi @MONALI_BHALERAO

Check this

How to add items to orchestrator queue without adding duplicates

How can i add items to my orchestrator queue without adding duplicates? Right now my bot checks another application for new work items (query), and then it adds these items to the orchestrator queue on a weekly basis. During the week the bots will pick up work items 1 by 1 and process them. How do i add new work items to the queue without adding items that are already in the queue? is there a way to check the work item # to be sure they don’t match before adding the item to the queue?

Thanks
Ashwin S

[MONALI_BHALERAO]

i know how to add queue but excel sheet data are different format when i was add in add to collation name write to University Name as Gujrat Technological University not mitali patel

[Pradeep_Shiv]

it’s writing as Mitali patil bc it’s in the same column and you gave your column name as “University Name”

[MONALI_BHALERAO]

i get value like this
([University Name,Gujrat Technological University,Column1,Column2,Column3,Column4,Column5,Column6,Column7,Column8
,
Student Name,Phone Number,E-mail,DOB,Semester Type,Course,Gender,File Path,Exam Date,
Patel Mitali,6320125689,mitali.patel@1rivet.com,09/10/1997 00:00:00,First Semester,Computer Engineering,Female,C:\Desktop\ExamRegistration_Form.png,10/12/2020 00:00:00,
])
hey Mrs look am use add bulk queue that not work proper
when i use add queue uipath given student name is no valid
i show you error is like this
(Add Queue Item: Column ‘Student Name’ does not belong to table DataTable.)

[harshit_singh]

Hi @MONALI_BHALERAO

Please check your read range is it starting from A4 or not ? If not, then update it with “A4” and also check add headers property it must be enable.

Hope it works.
Cheers!

[MONALI_BHALERAO]

but i want also university name and that value is
Gujrat technology

[harshit_singh]

@MONALI_BHALERAO Use read cell activity for University name in same loop

[MONALI_BHALERAO]

ok i’ll try

[Pradeep_Shiv]

you can select that entire row like this
ArrayOfDataRow = YourDataTable.Select("ColumnName = ‘UniversityName’ ")

[MONALI_BHALERAO]

can you give more detail bcoz i cant do it

[supermanPunch (Arpan)]

@MONALI_BHALERAO Can you Provide your Excel File?

[MONALI_BHALERAO]

Exam Registration Template.xlsx (10.7 KB)
Yes sure This my excel File

[supermanPunch (Arpan)]

@MONALI_BHALERAO Do you wan only the University Name?

[MONALI_BHALERAO]

Yes i want

[supermanPunch (Arpan)]

@MONALI_BHALERAO Check This, This will work only if the Format of the Excel doesn’t change University Value.zip (10.6 KB)