How to add New Rows in Conditional Match jmp 15

[#1]

Hello,

Is it possible to automatically add new matches to the formula?

My data contains a Conditional Match Formula to group data.

I.E. the data includes Rows like PartA-V1, PartA-V2, PartA-V3 and PartB-V1, PartB-V2, PartB-V3 that the matches would be PartA or PartB since the -V does not change what I am looking for.  The actual data is has more complicated descriptions.  The original data had ≈50 Matches so recreating the entire match table/formula is not easy.

The issue is - when new data, PartA-V4, PartC-V1, they are not included in the prior match functions.

Thank you for any assistance.

[#2]

If I understand correctly, you need a more general formula to group your data.

I would use e.g. "words" if the string has always a "-" and you need the first part, like follows:

Words("PartA-V1", "-")[1]