Hello Every community friends.
I come to ask question again.
in this sheet:
I only want get the D2 department’s salary or I just want konw the D2 department’s salary and ID in this sheet.
What activity I can use.
Please help me.
Thank you for your help.
1 Like
IF you have any confusion in my question, please let me know. My english is not so good. thank you.
1 Like
You can use Read Range to read your excel sheet into a data table and then use Filter data table activity to filter your rows with department as D2
Hi @chenzhixing.prc,
You can filter the datatable in the assign activity as below
Dt=Dt.select(“[department]=‘d2’”). copy ToDataTable
Regards
Sanjay shankhla
Hi @Chenzhixing.PRC,
- Use Read Range Activity within Excel application scope.
- Use Filter Datatable activity to filter.
- Use Write Range activity within Excel application scope to write the filtered table.
1 Like
Everytime I get a question and you always help my very soon.
Very appreciate.
Thank you.
1 Like
Yes I solve it Thank you !!!
1 Like
I solve it now thank you for your help !!!
1 Like
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.