How to exclude data points starting with a specific word from a PCA and followed by a graph builder?

[#1]

Hi,

I have a dataset where the sample name for some data points start with "Bad...". I want to exclude these data points starting with "Bad" from a PCA but they should still be visible in the plot.

After PCA I plot the PC1 and PC2 in graph builder and here I also want the same datapoints to be excluded but visible in the graph.

Is there a way to script this in JSL? So I don't need to manually exclude the data point from the data table.

I'm using JMP18.

Hope you can help. 

[#2]

You can use Select Where with Starts With to select those rows and then exclude them

Current Data Table() << Select Where(Starts With(:sample, "Bad")) << Exclude(1);

Then in graph builder, hold shift and click on red triangle to select show excluded rows

If you wish to show the values in Principal Components platform I think you would have to write a script for that using graphic script

[#3]

Hi, thank you for your reply!

Could you help me how the script would look if I want to exclude multiple files with specific sample names instead?

Thanks in advance

[#4]

If you are looking for full matches, contains() is one option.