Orchestrator queues & pdf

Hai,
I have one scenario like orchestrator queues unique reference.

    In excel sheet there is 28 rows some of duplicate rows will be there 
    In add queue item activity there is I am enabled references also, in orchestrator queues also I am enabled unique reference also. 
But In somehow some duplicate rows come into orchestrator queues. 

Now what it will be happened????? How it will be processed????
  1. In source folder I have 6 pdf files in that file I need to move destination folder into one pdf file how can we achieve this???

Thank you,
Sivasankar

If you don’t need the duplicate cases to be processed and add that in the queue

Try this way

  • use this below expression in your DTvariable

 (From p in io_TransactionData.Select() where( From q in io_TransactionData.Select() where q("ColumnName").Equals(p("ColumnName")) Select q).ToArray.Count=1 Select p).ToArray.CopyToDataTable()
  • Write Range and return the unique cases to new sheet and the pass that sheet to add the queue

Regards
Sudharsan

Before adding the excel file in to the orchestrator queue.

you need to remove the duplicate items.

for that use below query.

Dt.DefaultView.ToTable(True,"ColumnName").ToString

Then use Add Queue item

else use Bulk Add Queue Items

Regards,
NanI

Adding to above solution you can also maintain a excel status file where you can update…failed or processed.

Yeah okay this method is good

But what I am asking is some how duplicate values is passed into queues 
Now queue have original also and duplicate also, while bot is running now what it will be do, it will throw any error or it will be processed through duplicate values also ortherwise it will take only original values 
  1. What about pdf how can we save 6 pdf files into one pdf

Yeah okay this method is good

But what I am asking is some how duplicate values is passed into queues 
Now queue have original also and duplicate also, while bot is running now what it will be do, it will throw any error or it will be processed through duplicate values also ortherwise it will take only original values 
  1. What about pdf how can we save 6 pdf files into one pdf

For removing duplicate values from excel. i have already given a solution for that!

Then send it to the queue.

for this you can use join pdf files activity!

have a view on this thread

Regards,
NaNi