Hi Team i want to filter data based on column values

Help Studio
1

Hi All,

I have input excel cloumn “ENGG_OWNER_ID” based on values of the i want to group the other column values “DIRECTORY_NUMBER” how to do that can any one help me.

Example
ENGG_OWNER_ID=1157801
Directory_Number=2625997798
2625997799
2625997800
4142084481
4142084481
4142084482
4142084482
4142084483
4142084483
4142084484
4142084484
4142084485
4142084485
4142084486
4142084486
4142084487

image SalesOrders.xlsx (48.3 KB)

2

@thima

Can you share a screen of your output requirement?

Thanks

3

Out put shared above screen shot

4

@thima

Kindly use filter datatable activity to filter the rows in your datatable. I am posting sample exercise

FIlter_DataTable
FIlter_DataTable1385×709 27.5 KB

Thanks,
Deepika Y

5

Hi,

Engg_OWNER ID is dynamic it will not be same in that case how to do?

6

@thima

Column name can be change but the column position will be same right in your Excel? as per the below example column A2 denotes ENGG_OWNER_Id with diff name.

A1| A2
|Engg owner_Id or Engg Id or Owner Id or xyz

In this case, Use Build datatable activity and give column name by your own and read your excel using read range and uncheck add header property while importing to table. So now the column name would be static.

Thanks,
Deepika Y

7

My Requirement is based on ENGG_OWNER _ID i want to fetch the DIRECTORY_Numbers how to do that.can some one help me

8

Instead of mentioning column name you can give column index as well - dt.Column(2) in filter wizard