Adding unique reference to Data Table

Help Studio
, ,
1

Hi,
I have a data table that I like to upload to the queue with a unique reference. Datatable has a column “Employee ID”.

So in a for loop I am adding queue item with property Reference set to this Employee ID + DateTime.Now.ToString(“MMddyyyy”) format.

Does this work or do I need to create a refernce column in the data table itself with Employee ID value.

Please advise proper way of doing this.

Thank you,

2

Hi @A_Learner

You are using Add queue item within For Each row in DataTable right, the property set in reference will work for each row in the datatable.

Regards

1 Like
3

It’s much better to add a Reference column to the datatable then use Bulk Add Queue Items.

1 Like
4

For some reason, Bulk Add is failing. I will have to go with loop.

Thank you,

5

How about figuring out why Bulk Add is failing? Are you getting an error message?

6

Yes, really like to know why the bulk add fails. It gives me an error message.

Thanks,

7

What is the error message? You have to give us details or we can’t help.

8

Will get back. Thank you.

10

@postwick
Bulk add worked. No issues. Thank you for the good advice about bulk add.

11

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