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

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

artnik — Sat, 10 Jun 2023 23:57:06 GMT

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.

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

SDF1 — Wed, 16 Nov 2022 20:19:22 GMT

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