How can I revise the robot to get my expected outcome

[Happydayyy (22035153d)]

I need to classify the data based on “Type of sample” to different sheet from main sheet "MU-bias (Robot)

This is the main sheet:

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:

However, My result now is
(Within range’s sheet)

(Without range’s sheet)

Can anyone help me to revise my workflow so that the output can be the expected one? Many thx!!!

Excel
WB templ. 27.2.24.xlsx (77.2 KB)
Robot
MU-bias_new.xaml (9.4 KB)

[healsko_ho (Healsko)]

@Happydayyy
Your linq misses the handling for those rows which’s Type of sample is blank.
Attached the revised workflow for your reference.
MU-bias_new.xaml (14.1 KB)

[Happydayyy (22035153d)]

Thank you so much, the sheet of “MU bias (withinrange)” seems no problem, yet in the “MU bias (OUT range)” there is an issue like:

Can anyone help me to fix on it? Many thanks

excel
WB templ. 27.2.24.xlsx (84.3 KB)
Robot
MU-bias_new (1).xaml (14.6 KB)

[healsko_ho (Healsko)]

I executed the process again and no issue was found.
Please make sure those 2 worksheets are clean before execution or use append activity.

[Happydayyy (22035153d)]

thanks you so much!!!