How to solve filter problem in my case

[Happydayyy (22035153d)]

There is an error of assign the filter table, Can anyone help me to check on it and revise the path using my workflow? Thanks!

I need to classify the data based on “Type of sample” to different sheet.

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:

Workflow
Main MU-bias in-outrange.xaml (45.1 KB)

excel
WB templ. 27.2.24.xlsx (85.5 KB)

[ptrobot]

Test to change curly brackets to square brackets. E.g. {Type of sample} to [Type of sample]

[Uthraa_S (Uthraa)]

Hi,

Please try the below LINQ query to get the matched values

dtMainDT.AsEnumerable.Where(Function(row) row(10).ToString.Equals(“3N”) or row(10).ToString.Equals(“4N”) or row(10).ToString.Equals(“KR”) or row(10).ToString.Equals(“Kw(Pd)”) or row(10).ToString.Equals(“Kw(Ni)”) or row(10).ToString.Equals(“Ky”)).CopyToDataTable

[Krishnakanth_Mathi]

Hi @Happydayyy,

The expression you have used is wrong in the assign activity. I have executed the code with changes, you can use this sample file
MU-bias_new.xaml (9.1 KB)

Please let me know if required any further help.

[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:

[Happydayyy (22035153d)]

May I ask that is it feasible to do it in the expected manner?