Add Prefix to only rows in column with text

[mmarchioni]

I have a column where I would like to add a prefix to only those rows that have text.

What I have:

24

Blank

10

12

Blank

What I get when I add the prefix:

A24

A

A10

A12

A

What I want:

A24

Blank

A10

A12

Blank

I would like to keep the blank rows blank.

Could you please provide some guidance?

[mmarchioni]

I still ended up with an A in the Blank rows.

[Samarth_18]

Could you please share what you have tried and what output you are getting? 

[mmarchioni]

I created a column with

A2with_prefix =

IF ( NOT ( ISBLANK ( rvTX[Related Patient.A2Cd] ) ), "A" & rvTX[Related Patient.A2Cd], BLANK () )

And still got A's in the rows that were blank. The columns are formatted as text and not numbers (I am not sure if that makes a difference).

[Samarth_18]

Based on your requirement your code would be like this:-

A2with_prefix =
IF (
    NOT ( ISBLANK ( rvTX[Related Patient.A2Cd] ) ),
    "A" & rvTX[Related Patient.A2Cd],
    BLANK()
)

[mmarchioni]

That is what I tried.

[Samarth_18 · Accepted solution]

You have updated your comment 🙂

Anyways you can try below approch:-

A2with_prefix =
IF (
    Trim(rvTX[Related Patient.A2Cd]) <> BLANK(),
    "A" & rvTX[Related Patient.A2Cd],
    BLANK()
)

[mmarchioni]

Works great! Thanks!

[Samarth_18]

HI @mmarchioni ,

You can create column with below code:-

with_prefix =
IF ( NOT ( ISBLANK ( prefix[Column1] ) ), "A" & prefix[Column1], BLANK () )

Thanks,

Samarth