nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

570204_en-US

liliconcom

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

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.

Analytics

Data Table

DOE

Scripting

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

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!,

Comments

There are no comments yet