cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Check out the JMP® Marketplace featured Capability Explorer add-in
Choose Language Hide Translation Bar
artnik
artnik
Level I

Compare and match characters from 2 different columns and call on ID as output

Created: Nov 16, 2022 02:37 PM  |  Last Modified: Jun 10, 2023 4:57 PM (557 views)

Hello. I need some JMP formula help. I have 4 columns in one data table: concat name, concat sequence, consensus name, consensus sequence. I would like to match characters in the JMP cells from the column concat sequence to the column consensus sequence to find a match, but I want the output to call on the concat name. I'm just doing a matching game between two columns' values, but I want it to call on a different column as the output. 

 

Any help with this is appreciated. Thank you.

0 Kudos
1 REPLY 1
SDF1
Super User SDF1
Super User

Re: Compare and match characters from 2 different columns and call on ID as output

Nov 16, 2022 03:19 PM (552 views)  |  Posted in reply to message from artnik 11-16-2022

Hi @artnik ,

 

  Can you share an example of the input columns and desired output columns? I think you can do this a few different ways, with Regex, or Contains, or Starts/Ends With, but without know what the data looks like filling in the columns your describing, it's difficult to imagine how this could be dealt with most efficiently.

 

Thanks!,

DS

0 Kudos