Excel activities11

Help
,
1

In an excel sheet having 20000 employees data
So in that I have to process unique employee id say for example 089652 having 10 rows I have to take out the unique employees id to a data table… Give me fine Sol for this …

2

@prasssaadd,

Use “Excel Application Scope” and “Read Range” activity to read the excel as a datatable since it has more number of rows.

Then use filter datatable and for that ID column filter with the required value.

03
03776×375 19.2 KB

1 Like
3

One way you can do this is to use the Excel Application Scope Activity to use the Read Range Activity and export the DataTable to a variable (we’ll call it ExcelDT).

From here, using the Assign Activity, you can do the following:
ExcelDT = ExcelDT.DefaultView.ToTable(true, "<col1>", "<col2>", ...)

where <col1>, <col2>, etc are the columns you want included in the final DataTable.

Note: Assigning the new DataTable to the same variable will overwrite the previous DataTable, if you will need to access that information again in the future, you should create a new temp DataTable variable to assign the filtered DataTables to.

Example Dataset:
[ID] [food]
1 pizza
2 hot dog
1 hot dog
2 pizza
1 pizza
1 cheeseburger
2 hot dog

Example One:
ExcelDT = ExcelDT.DefaultView.ToTable(true, "ID")
Output Dataset:
[ID]
1
2

Example Two:
ExcelDT = ExcelDT.DefaultView.ToTable(true, "ID", "food")
Output Dataset:
[ID] [food]
1 pizza
2 hot dog
1 hot dog
2 pizza
1 cheeseburger

In the first example, since we only selected the first column ID, the returned DataTable returned ONLY the unique items from that column.

In the second example, we selected the first column ID AND the second column food. The new DataTable as a result returned any and all UNIQUE combinations of those two columns, this is why we see repeats in both ID and food.

1 Like
4

So after extracting the unique data… How we can construct a queue for this unique data

5

So …in that case if I want food as hot dog only… And construct a queue for this unique data… How?

6

@prasssaadd,

By using For Each Row activity with the filtered datatable, for each row you can add it into the Queue as a DataRow item. Then you can use it as datarow.

7

It came like this

1572415454745-126418354
1572415454745-1264183541560×2080 1000 KB

8

@prasssaadd,

Check this xaml, I have looped a datatable and added each row as an queueitem in a Queue.

You need to change the datatable name, Queuename.
DataTableToQueue.xaml (5.6 KB)

9

Thank you @sa[date=2019-10-30 timezone=“Asia/Calcutta”]:expressionless:

Blockquote

10

Thank you @sarathi125

1 Like
11

Mark the post resolved if it is resolved your issue.

12

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