I want to add >, " || :A, !IsMissing( :B ), " ); How can I cancatenate special characters to columns?

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; } } }

Concat special characters?

amy

I want to add >,< symbols to 3 columns that have numbers. Trying to do something like this:

s = dt << New Column( "Added Symbols", character
Formula(
If(
!IsMissing( :A ), ">" || :A,
!IsMissing( :B ), "<" || :B,
!IsMissing( :C ), "=" || :C
)
)<BR />);

How can I cancatenate special characters to columns?

Accepted answers

uday_guntupalli

@amy,
What are you trying to achieve ? If I understand what you have shared correctly, I made a few assumptions and did the following:

If( !Is Missing( :A ),
	">" || Char( :A )
  )

The formula I used is shown below. If the data in your column is numeric, you will not be able to concatenate, it will have to be cast into a character as shown above. If this is not how your data looks , please share a sample of your data

All comments

uday_guntupalli

@amy,
What are you trying to achieve ? If I understand what you have shared correctly, I made a few assumptions and did the following:

If( !Is Missing( :A ),
	">" || Char( :A )
  )

amy

My data is similar. I am trying to do the exact same thing. I tried converting to char like you did, but its still not showing up an output in a new column.

example data.jmp

amy

It worked!! Thanks