Queues - reference

Help Studio
,
1

Hi,
I am reading an excel sheet into a data table. Now I like to add this data table to queue with unique reference as one of the columns, employee id. Instead of looping through all the rows, how to use LINQ query to add this column “reference” with values from “employee id” column?

Thank you,

2

Hi @A_Learner

As you have stored data into Excel you will read it using read range & you will get output of that in datatable variable.

You can use this datatable variable in activity called Bulk add queue items. No need to use for each loop.

You can use this linq statement if you only want to take one column from entire database.

DT1 = DT1.DefaultView.ToTable(False, {"Employee ID"})

Hope this helps :slight_smile:

1 Like
3

@A_Learner

You dont need to use linq also can use this in assign…before that use add data column and add the reference column uou need

Dt.Columns("Reference").Expression = "[Employee ID]"

Cheers

3 Likes
4

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