Classification of data to different sheet

[Happydayyy (22035153d)]

Hello everyone, may i ask how I can classify the data based on “Type” to different sheet?

This is the main sheet:

If the those data’s “Type” is 3N, 4N, KR, Kw(Pd), Kw(Ni), Ky, then all data will go to sheet “MU-bias (Within Range)”, like this sample:

But if those data’s “Type” other than 3N, 4N, KR, Kw(Pd), Kw(Ni), Ky, then all data will go to sheet “MU-bias (OUT Range)”, like this sample:

Can anyone help me to solve this problem in addition to
Main MU-bias semi-final.xaml (42.6 KB)

Excel file:
WB templ. 27.2.24.xlsx (67.2 KB)

Many thanks

[postwick (Paul Ostwick)]

Read Range into datatable
Filter Data Table (Type = 3N or Type = 4N etc) into a new datatable
Filter Data Table (Type != 3N and Type != 4N etc) into another new datatable
Write Range the two datatables to the sheets you want

[Happydayyy (22035153d)]

After I revised my workflow and add the filter activity:

The result of “within range” sheet is:

“Outrange” sheet is:

But it is not my expected result, Can anyone show me how to revise the workflow and achieve my expected result? Many thx

Updated workflow:
Main MU-bias in-outrange.xaml （50.9 KB）

Excel
WB templ. 27.2.24.xlsx (85.5 KB)

[postwick (Paul Ostwick)]

How is it different from your expected result?

Show us how you have the Filter activities configured.

[Krishnakanth_Mathi]

Hi @Happydayyy

Please find the sample code which will resolve your issue

MU-bias_new.xaml (9.1 KB)

Please let me know if any further help required

[Happydayyy (22035153d)]

My result now is
(Within range’s sheet)

(Without range’s sheet)

But How can I revise the result as:

(inrange sheet)

(outrange sheet)

Excel:
WB templ. 27.2.24.xlsx (77.2 KB)
Robot:
MU-bias_new.xaml (9.4 KB)
Can anyone help me to revise it? Many thxxx

[Krishnakanth_Mathi]

Hi @Happydayyy,

Can you please be more specific about what ur expectation is.

We are not able to understand what’s your ask is

[Happydayyy (22035153d)]

My task is to tranfer a set of data from “MU-bias (Robot)” to “MU-bias (Within Range)” and “MU-bias (OUT Range)”

If the those data’s “Type of sample” is 3N, 4N, KR, Kw(Pd), Kw(Ni), Ky, then all data will go to sheet “MU-bias (Within Range)”, like this sample:

But if those data’s “Type of sample” other than 3N, 4N, KR, Kw(Pd), Kw(Ni), Ky, then all data will go to sheet “MU-bias (OUT Range)”, like this sample:

[Krishnakanth_Mathi]

Hi @Happydayyy,

If my solution worked out can you please mark it as a solution.